其實ibm和powerdesign 也都有相關的軟體

只是搭配起來價格不斐

有興趣的也可以去看看相關的說明

最近發現oracle devloper 有一個export schema 的功能

可以將所有schema 變成像是網頁式的查詢

其實這個功能很方便

如果可以定期由語法產出

應該是很棒的內部文件查詢系統

http://www.codeplex.com/datadictionary

Take a look at this DDC Walkthrough to see how easy it is to document your database.

Version 1.3.1 (17/07/08)

• Schema/owner support. dbo.tblTest & core.tblTest will be handled as seperate tables
• Screen improvement. Window resizing will now stretch controls to take advantage of the available space
• Fixed bug when connection to SQL Server Express
• Export to SQL will now escape single quotes
• Start menu folder will no longer be named (Default)
• xls templates will display table schema/owner
• Other minor adjustements

• Added documentation of tables as well as columns
• Changed Excel export from HTML based to XMLSpreadsheet to support separate worksheets for Table and Column documentation
• Improved error handling - detection of non-DBO logins, etc.
• (UI) - tab reorganization to fit workflow a little better
• (UI) - moved feedback and progress bars to statusbar for consistency
• Support for SQL 2000 and 2005 export scripts (there were several breaking changes from 2000 to 2005)
• Limited import functionality (SQL and XML)
• Added Installer

• T-SQL export to allow copying documentation between database instances (thanks, Tyler!)
• Loads previously used additional properties from database on connection
• User interface enhancements
• Bug fixes