SQL Table report

[gbraden]

Does anyone have a script that I can run on our sql server 2000 that will give me a neat (printable) report of my tables. I use to run a script on Oracle that would dump my table description by column name, data-type and length and broke by table name and was filtered by owner.




Glen Braden

 

[mrdenny]

Take a look at the INFORMATION_SCHEMA.COLUMNS view. It should have all the info that you are looking for.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog