Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting a table design

Status
Not open for further replies.
mellenburg11

mellenburg11

Programmer
Aug 30, 2004
9
US
I need to export a table's design for documentation purposes. The only think I've been able to do is export the data. How can I export the field names, data type, length, and the allow nulls flag?
 
Sort by date Sort by votes
Select the table name from EM. Right click and select the following:

All Tasks
Generate SQL Script
Select Preview to view the script or OK to export it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
349
iambob
iambob
TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
307
TheBugSlayer
TheBugSlayer
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
399
fredericofonseca
fredericofonseca
tekpr00
  • Locked
  • Question
Hello I am new to a new organizatio
Replies
1
Views
127
johnherman
johnherman
tekpr00
  • Locked
  • Question
Backups in a multiserver environment while using Central Management Server and Server Groups
Replies
0
Views
160
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top