Data dictionary creation

[robmason10]

Please excuse the 'newbie' style of the question.....

I have been asked to create a data dictionary of a SQL database whereby I would like to detail (to an exel ssheet) the following info from all tables and views in a database...preferably all in one go...

table name
col name
data type
length
allow nulls

I would appreciate any advice on how best to approach this...

Thanks in advance.

 

[JayKusch]

No real easy way to do this. You could script out the tables and write an app that cleans up the script into a format you could use. You could also look into a cheap app that reports what your are after. One that comes to mind, that is inexpensive would be SQL Insider.

Thanks

J. Kusch