February 20, 2008 at 3:50 pm
Is there a script for buliding a data dictionary for an existing database here on this site?
thx
John Esraelo
Cheers,
John Esraelo
February 20, 2008 at 4:27 pm
How familiar are you with SQL Server Management Studio? You could script out the database tables and format it to fit your "data dictionary" needs.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
February 20, 2008 at 9:34 pm
I have been using:
use mydatabase
go
select *
from information_schema.columns
of course I write this information to a table (mydatabase.dbo.mydictionary) and then take it to my authoring tools for preparing a document.
I was just wondering if there was a better way of doing it.
John Esraelo
Cheers,
John Esraelo
February 25, 2008 at 4:35 pm
If you're looking for a compiled help file, try this:
February 26, 2008 at 5:17 am
there are some tools to do this such as Apex SQLDOC or you can use the built in meta data functions.
February 27, 2008 at 8:17 am
I found two in the scripts listings here. One works great on SQL 2k5, the other for 2k. I modified them to accept the database to store the data dictionary in, as well as the database to perform on, and a snapshot datestamp.
I have a weekly job that does an sp_msforeachdb run of the procedure to capture what the dictionary looks like at the beginning of the week. I do this to keep an eye on developers that won the battle to have Sa level access before I began where I am.
February 27, 2008 at 8:48 am
You can also use tools like ERWIN, EMBARCARDEO and datacompare to just generate the scripts of your tables for you. but the best is to use the SSMS for that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply