June 7, 2010 at 9:34 pm
Hello Folks
This question is for Vets in SQL Server Management Studio.
We have a Data dictionary in SQL Server. When i say Data dictionary i mean the extended properties of columns and tables . More clearly when we right click a filed name and add more infor to it..
Ex: Rtd_Emp_Age (In properties we add the following info : This filed stores the age info of all retired employees of accounts dept ..blah blah..)
By observing more
we also see that
it is FK to some other table
It is a small-int
It doesn't allow NULLS
Blah..Blah..
OK .. So what do i want ?
Lets assume that i clearly populated this info to all my tables n fields..
CAN I EXPORT THIS DATA INFO (META DATA) in any format out of management studio.
So that i distribute that file among NON - IT dept folks.. so that they know what column is what.
Hope you got what i want.
As i am designing a new DB from scratch, i just want to avoid the need of building exclusive Data Dictionary. by using extended properties of SQL Server.
Please Help
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 9, 2010 at 11:51 am
take a look at fn_listextendedproperty in BOL. this will enable you to query the extended properties, from there you can come up with some kind of report.
June 9, 2010 at 12:18 pm
Thank You for ur advice, i will check it out.
Anyways i FOUND this Wonderful article which does my job a lot easier
Data dictionary in seconds .. I am thankful tot this author.
http://www.mssqltips.com/tip.asp?tip=1499
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply