Solved

Export Table structure SQL 2005

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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 to return specific rows and columns, with various degrees of sorting and limits in place.

895 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now