Document SQL Server 200/2005 Database : 產生資料庫設計文件 (Output Database Schema in HTML)

Download script - 3.26 KB

Script_to_generate_DB_Document_Version_1.1.sql

Follow these steps to use this script:

• Download the attached script file and open it in Management Studio (tested on version 9.00).
• Select the database for which you want to generate document.
• Select Result to File (Ctrl+Shift+F) from Query - Results To menu.
• Execute (F5) the script.
• In the Save Result dialogue box, type a file name (filename.htm/filename.html) in the File Name text box and select All Files (*.*) in Save As Type dropdown.
• After successful execution of query, check the output file.

Note: For populating the description of table and columns, update the Description property of table and columns while creating database diagram or add extended property for them with name as MS_Description.

資料來源 ： http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx