Wednesday, March 21, 2012

Data Dictionary

hi what is a data dictionary and can anyone give me an example / sample of
it?
thankshttp://www.answers.com/data%20dictionary%20
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"ichor" <ichor@.hotmail.com> wrote in message
news:%23YzwJNXnFHA.3448@.TK2MSFTNGP12.phx.gbl...
> hi what is a data dictionary and can anyone give me an example / sample of
> it?
> thanks
>|||"ichor" <ichor@.hotmail.com> wrote in message
news:%23YzwJNXnFHA.3448@.TK2MSFTNGP12.phx.gbl...
> hi what is a data dictionary and can anyone give me an example / sample of
> it?
Here are a couple of links on it as well as one that has a script to
generate the information from Sql Server.
http://www.dthomas.co.uk/src/reques...r
ticles
http://searchsqlserver.techtarget.c...1114748,00.html
Here is page with a script that works out of the box as well as turning into
a function:
http://codebetter.com/blogs/raymond...3/04/56519.aspx
Tom

> thanks
>|||It is a repository of meta-data ("data about data"). Google for
packages that do this kind of thing.
A good DD will also alllow you to store code for generating your code
(i.e. you click on "client_nbr" and you get the constraints when you
create DDL)sql

No comments:

Post a Comment