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.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-06-26 : 22:49:28
|
| Hello All,How would I create a data dictionary using the MS_Description columnin the extended properties and the information_schema columns? Iwould like to include table name, column name, data type, null/notnull, ms_description, and etc...Has anyone done this or created a data dictionary in SQL Server anyother way before? Please advice. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-27 : 01:44:07
|
| you already have all this information available via catalog views like INFORMATION_SCHEMA.TABLES,COLUMNS,.. then why create a new dictionary?You can store extended properties using sp_addextendedproperty system stored procedure |
 |
|
|
|
|
|
How to create a data dictionary