Menu

How do I export the database structure in SQL Server?

0 votes

I would like to export the structure for the Microsoft SQL Server tables that I am having issues with.

in How To by (7.0k points)
Share on
share on gp share on fb share on tw share on li

1 Answer

0 votes
 
Best answer

The following instructions explain how you can script the Database objects you want to export.

  • Open "Microsoft SQL Server Management Studio"
  • Right-click on the Database you want to export
  • Select "Tasks / Generate Scripts..."
    This will open the "Generate and Publish Scripts" wizard.

  • On the "Choose Objects" tab:
    a) pick the table and all related tables you are having issues with.

  • On the "Set Scripting Options" tab:
    a) Select "Single File"
    b) Click Advanced Options and select "Table/View Options" / "Script Indexes"

by (64.3k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

table-view error lookup-field security action-button user-interface css form-fields advanced-search table-grid reporting customizing stored-procedure installing tables import attachments url authentication export single-sign-on user-help active-directory login sqlserver database-connection foreign-key field-preferences email performance pdf-form license cascading-lookup search custom-visibility themes mysql table-relationships quick-search drop-down-list logo excel printing notifications date-field primary-key iis azure backup upgrading database webrequest costed sidebar-help user-profile multi-select main-menu attachment-properties iframe numeric-field table-preferences access-control record-locks timeout sorting multilingual header connector audit support csv oracle display hosting connection help html-fields whitelisting child-tables session-key-failure wildcard-search font-size caching save-button row-security default-value barcode network-file local-file integrations logout custom-sorting validation custom-caption debugging ldap xml checkbox user-alerts database-preferences
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...