>Is there an easy way to print or export a data structure/dictionary from a SQL Server 2000 database? I can create a data diagram, but I have 41 tables and just laying everything out is a pain. Does anyone know of a simple routine to create list of tables, fields, descriptions, etc.?
>
>Thanks,
>Doug
Doug,
You could use
-SQLTables and SQLColumns (see faq#8039)
-sp_help* procedures
-INFORMATION_SCHEMA ie:
SQLExec(lnConn,"SELECT * from pubs.INFORMATION_SCHEMA.TABLES",'TableList')
Cetin