reporting defined objects

[dboira]

I have defined a database with some tables and I want obtain a report for each defined table. How is possible to make this with SQL Server 2005?

 

[gmmastros]

What do you want on the reports?

Take a look at the Information_Schema views.

Ex.
Select * From Information_Schema.Tables

Select * from Information_Schema.Columns

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dboira]

Thanks for your help. But I would like something like a document with the name of the table, then all the columns with its data type and more information. It is possible that tuning the select I can obtain this but there is not any utility -I think- in the SQL Server Managment Studio to make it easier.

 

[vbkris]

sp_help sp???

Known is handfull, Unknown is worldfull