Wednesday, March 21, 2012

Data Dictionary

In SQL 2000 is there a way to generate a data dictionary of an existing database? If so how do you go about doing it? In Access it has a documenter that will create one for you. ThanksSQL doesn't really have a tool like that, but there are a couple of things
you might do.
1. Right click a database in SQL Enterprise manager -> all tasks -> generate
Sql script...
2. Go to metadata in Enterprise Manager (under Data transformation services)
and import metdata...
Neither is really what you are looking for I suspect
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:C5866E7F-E6A7-4791-8F28-2C82E3343984@.microsoft.com...
> In SQL 2000 is there a way to generate a data dictionary of an existing
database? If so how do you go about doing it? In Access it has a documenter
that will create one for you. Thankssql

No comments:

Post a Comment