SqlDoc Document your SQL Server database
Download

SqlDoc Ranking & Summary

SqlDoc Tags

database SQL Server MSDE SQL Server Database Document Database database document MSDE database

SqlDoc Description

The SqlDoc application was developed to be a small command prompt utility to help you document your SQL Server / MSDE database. In SQL Server, every property of tables, fields, relations, etc. are stored in a few system tables. You can query those tables to extract info about your database. SQL Server provides a mechanism to simplify the queries to those system tables: Information Schema.Try to run the command "SELECT * FROM INFORMATION_SCHEMA.columns" in any database. A list of every column in every table in the database will be returned.I code this utility to auto document my databases, extracting table names, columns names, field types, lengths, and nullable columns, and generate a HTML file with that info. You can tweak the queries to extract any other info that you need.There is a special piece of info that is not available through Information Schema: column's description field. I find it very useful to fill that field when I design a table, to clarify the purpose of a column. To extract that description, you must bypass Information Schema and query directly the system tables.The inner working of this app is very simple. It gets the results of special queries, and writes an XML file which is used in combination with an XSLT file to produce the final HTML file.You can quick test the utility, extracting info about the Northwind database, typing:SqlDoc.exe -E -d northwind

SqlDoc Related Software