Solved

Export Table structure SQL 2005

Posted on 2010-08-24
3
343 Views
Last Modified: 2012-05-10
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
Comment
Question by:GSLElectric
  • 2
3 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33517402
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
 

Author Comment

by:GSLElectric
ID: 33517408
I'm wanting the structure for the entire database
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 500 total points
ID: 33517422
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question