Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-06 : 07:37:21
|
| Debi writes "I am writing technical documentation on our SQL Server product and need to be able to output all the table definitions so that I can cut and paste it into my documentation. I tried using sp_help tablename, but that gave me the number of bytes in the Length for all Unicode fields. I need the exact information that you get when you right-click on a table and select Design in Enterprise Manager." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-06 : 07:43:14
|
| you can use Generate Sql Script Option.Right Click on the database ,Click on Generate Sql Script in All Tasks tab. you will get all the table definitions.HTH--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-06 : 08:18:16
|
HiOr if you don't want complete DDL statements in your documentation you have a few other options.One is, you can just take a screenshot of the diagrams in enterprise manager and paste them in.OK, I don't like that option either  Second, is get a copy of Visio. It will reverse engineer your database and is very good for formatting stuff like that. Plus it is very MS Office friendly (even before MS bought them) so if you embed a visio diagram, you can always double click and edit it in Visio.The third option is one of the 3rd party SQL documentation tools. There is a good review with lots of screenshots over here http://www.sql-server-performance.com/total_sql_analyzer.aspHope that gives you some ideasDamian |
|
|
|
|
|
|
Output Database Design