Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

Export Table structure SQL 2005

I have a third party helping me design an application.  I would like to send them a copy of just the table structure from our accouting software's SQL 2005tables.  Is there a way to do so without backing up the data as well?

0
GSLElectric
Asked:
GSLElectric
  • 2
1 Solution
 
cyberkiwiCommented:
In SSMS, expand Databases, <thedb>, Tables,
highlight the table you are after,
right-click, choose "Script table as", "create to", "Clipboard"
Paste into your email/document

Errata: this does not show any links to other tables, and is just the structure of one table.
0
 
GSLElectricAuthor Commented:
I'm wanting the structure for the entire database
0
 
cyberkiwiCommented:
All tables and objects:

Databases\<the db>
right-click, task, generate script
check: Script all objects in the selected database
Finish

Instead of all objects, you can instead use Next to enter the wizard and fine tune what you want exported.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now