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.
| Author |
Topic |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2002-09-25 : 08:13:05
|
| I'm looking for advice in creating a data dictionary for a SQL Server application. I don't have ERWIN or anything simimar but could probably get it if needed. The application is about 120 tables, maybe an average of 8 columns per table or so. It is still undergoing development so I want to create a dynamic dictionary.My current thoughts are to use Access to link to syscolumns and store the column descriptions in Access (I'm on SQL7). Access then can generate the dictionary through its report writer. If new elements are added to the database, they would automatically show up in the data dictionary (without a description)Anybody tried this approach? |
|
|
|
|
|
Creating a data dictionary