Automatic database documentor utility for Microsoft SQL Server databases
The SQL Server Documentation Tool automatically builds high quality technical documentation for Microsoft SQL Server 7.0, 2000 and 2005 databases. The technical documentation is created in HTML, HTML Help, RTF and plain text formats. The HTML Help format documentation is fully searchable and cross referenced and has a useful index. The SQL Documentation Tool documents SQL Server Tables, Views, Stored Procedures, Triggers, Table Relationships, Dependencies, Full-Text Catalogs, Jobs and DTS Packages. The new SQL Server 2005 MS_Description field is fully supported. Free trial version available for download. Documentation tools also available for ASP, and the .NET Framework (VB.NET and C#).
The SQL Documentation Tool documents the following entities in a Microsoft SQL Server database:
* Tables
o Column names
o Whether column is a primary key
o Column data types
o Column lengths
o Whether column is nullable
o Table relationships to primary and foreign keys
o Triggers associated with each table
o Table indexes
o Dependency information.
* Views
o Column names
o Column data types
o Column lengths
o Whether column is nullable
o Dependency information
o SQL script for creating each View.
* Stored Procedures
o Column names
o Column data types
o Column lengths
o Dependency information
o The Create Procedure SQL script for creating the stored procedure.
* Functions
o Column names
o Column data types
o Column lengths
o Dependency information
o The Create Function SQL script for creating the stored procedure.
* Triggers
o Shows which table is associated with the trigger.
o Shows which SQL actions (insert, update, delete) the trigger is associated with
o Dependency information
o The Create Trigger SQL script for creating the trigger.
* Full-Text Catalogs
o Shows the full-text catalogs that may be associated with a database.
o Shows the tables and table columns in each full-text catalog.
* For each database server documented, the SQL Documentation Tool can optionally include the following:
o DTS Packages
+ Details of DTS Packages.
o SQL Server Agent Jobs
+ Details of scheduled jobs.
+ Steps associated with each job.
+ Each job's schedule.