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 - 2005-10-24 : 09:44:11
|
| Shaun writes "HiI need to know if there is a tool or a way I can get a Database Diagram of one of my databases. I need all the tables, as well as field names, field type and field length, and the number of records in each table.At the moment there are 152 tables. It's going to take me for ever to do a Database Diagram with Visio.Please let me know if there is a way I can get it done with some tool or somethingSQL version : 2000Win Server Version : MS server 2003ThanksShaun" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-10-24 : 13:34:09
|
| Try diagrams for the database in enterprise manajor.If you just want the text the use the information_schema views.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Question