Export table structure on Sql server 2008

来源:互联网 发布:指弹中国淘宝店 编辑:程序博客网 时间:2024/04/27 12:55

I just tried the first one, it works

1. Create a script  of the table's definition.

 From Management Studio in Object Explorer,  right-click the table and point to Script Table as and then select Create to and choose to save it to a file.

or for SQL Server 2000

From Query Analyzer, right-click the table and select Script Object to File as and then select Create.

 

2. Use sp_help.

From either Management Studio or Query Analyzer run the following statement.

EXEC sp_help ('your_table_name')

3. Create a database diagram.

See Books Online topics for creating database diagrams. (although your print options are somewhat limited with this).

http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/f124a182-7e31-410c-a27b-b3cb9072f5e3/

原创粉丝点击