Data dictionary - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Data dictionary

Author

Topic

trueblueg8tor
Starting Member

1 Post

Posted - 2010-06-14 : 12:58:42

Thanks for reading. How can I get the data dictionary for a db in MS SQL Server 2008?

X002548
Not Just a Number

15586 Posts

Posted - 2010-06-14 : 13:35:48

Depends on what you mean by data dictionary

Try this

SELECT * FROM INFORMATION_SCHEMA.Tables

SELECT * FROM INFORMATION_SCHEMA.Columns

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources