An old friend of mine message me yesterday to ask for a utility that can extract SQL server tables definition and document it. Instantly an old but a useful tool comes to my mind, SQLDoc. It is a small command prompt utility that can help to automatically document your SQL Server/MSDE database. SqlDoc can extract the following table info: table names, columns names, field types, lengths, nullable columns, and field description. Its usage is simple, from the command prompt just run SqlDoc with the necessary parameters as shown below,
The output file is in HTML format (default is output.html) like the sample below.
SqlDoc is opensource software so which you can customize so you can retrieve other table info or omit information that you don't want to be documented.
0 comments:
Post a Comment