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 |
|
Ghanta
Yak Posting Veteran
96 Posts |
 Posted - 2010-11-30 : 11:41:04
|
| Hi Guys,I do not want to re-creat the wheel so wanted to check with experienced folks if they have script to create tables for creating a simple data dictionary database for SQL Server objects... something like Entity, Attributes, Relationship, etc tables.... Thanks a lot. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-30 : 11:47:12
|
| When building a new system I tend to hod all that in an excel spreadsheet, populate a metadata from that then create the tables (and everything else) from that.The metadata table becomes the data dictionary for the physical database.Later on the metadata table gets reverse engineered and checked against the spreadsheet to make sure changes are documented.This depends a lot on how the database is maintained - if there's something like an automatic update from the systest system then this would change the metadata table when it is applied - if the update scripts are prepared separately (e.g. if the system needs a lot of data manipulation with the release) then I would probably update the metadata after the event.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2010-11-30 : 11:57:22
|
| Thanks Nigel good idea. But I need to create simple data-dictionary which can be viewed using a browser... so just needed script for tables I can use to create that simple data dictionary database... thanks for your suggestion. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-11-30 : 12:51:11
|
You can use information_schema to make views...Google for information_schema and data dictionary..there is lots of code out there. I did something similar on databases where i pulled in the column info and extended properties for the description.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Data Dictionary Database