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.3k 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 (65.1k 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 table-grid advanced-search form-fields user-interface stored-procedure css reporting customizing installing tables import url export attachments authentication single-sign-on user-help active-directory login search sqlserver database-connection foreign-key license field-preferences custom-visibility email performance pdf-form cascading-lookup themes mysql date-field backup upgrading table-relationships quick-search drop-down-list logo refresh excel printing notifications primary-key iis azure 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 link 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
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...