Posted by Erland Sommarskog on 06/13/06 21:55

metaperl (metaperl@gmail.com) writes:
> We have enterprise manager for sql server 2000. I would like to store
> comments about my database schema somewhere in the database. I want to
> store information about the intent of tables and columns.
>
> We have EM but I am open to any suggestions regarding products.

You can use extended properites to this end, and that will inded put
data about the database into the database itself.

For more heavy-duty tools for data modelling, the three biggest tools
on that market are, I believe, PowerDesigner (from Sybase), ERWin
(from Computer Associates) and Embrocadero. These tools comes with a
price tag, though.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]