New to DataDictionary - 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

New to DataDictionary

Author

Topic

benildusmuerling
Yak Posting Veteran

81 Posts

Posted - 2012-03-21 : 00:26:21

Hi All,

I have been assigned for a project of datadictionary, to start from scratch, can anyone recommend me the steps, or the perfect kickstart to proceed with it, cause I am clueless, and do not know to where to start from and where to end.

Thanks,

Ben

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-21 : 01:03:59

A Data Dictionary is the definition of all the database objects

Start with the Tables

Describe what each table is for and what it holds

Then do it for each column.

I think it's one of the most important things to do, so everyone is on the same page. Usually it's the Business Partner/Liason's job to fill out the definitions

It is VERY Common that this never gets done.

Do a SELECT * FROM INFORMATION_SCHEMA.Tables, and then SELECT * FROM INFORMATION_SCHEMA.Columns.

Save Both to a spreadsheet and Combine into 1 tab, add a column called definition and ask people what each and everyone means.

I like to create Dictionary tables that I can load and join to the schema view if need be for context sensitive help

Good Luck

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

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

benildusmuerling
Yak Posting Veteran

81 Posts

Posted - 2012-03-21 : 01:43:03

Hi Brett and All,

Many thanks, but I would like to go into detail farthermore, asking to provide me with an example for the additional column that you asked to add, which is definition.

eg : lets say of the 'SELECT table_catalog,table_schema,table_name FROM INFORMATION_SCHEMA.Tables' returns the first row as INTT,dbo,subjects, and I copy and take it to excel and add the definition, what could I write on the subjects table as per to your findings.

I have copied the whole lot into one spreadsheet and worksheet, is that all I needed before presenting, dont I need any diagram, if so please suggest me

Thanks,

Ben

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources