Solved

Export Table structure SQL 2005

Posted on 2010-08-24
3
357 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

733 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