SQL Server 2000 or 2005 - Data dictionary

[ReportDr00]

Hi

How do i get the data dictionary for my database i.e is in SQL Server 2000. I know i have to query the system tables, but is there any queries or stored procedure already exists that get me all the information of my tables and fields (like name, data type, length etc)

Armani

 

[gmmastros]

Start with Information_Schema.Columns.

[tt][blue]Select * From Information_Schema.Columns[/blue][/tt]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[PatriciaObreja]

sp_tables and sp_columns

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium