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)

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.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer