SQL Data Dictionary

SQL Data Dictionary is a solution developed with the sole purpose of helping you extract information about an SQL database and exporting it as detailed documentation.

SQL Data Dictionary is a tool that won’t waste your time when it comes to installing and connecting it to a database, as both of these are done in a couple of seconds. As far as the installation goes, its represented by the classic Wizard approach in which all you have to do is click the ‘Next’ button, no settings to go through, no configuration options to confuse you.

To establish a connection, the only requirements are to enter the server name, choose between Windows or SQL Server authentication methods, select the target database and finally, click the “Ok’ button.

Once you’re connected to the database, the application allows you to choose whether you want to script all existing tables or just specific ones. To make reports as accurate as possible, the application allows you to toggle indexes, references and row counts.

The PDF document generated with SQL Data Dictionary displays the gathered information in a very neat and easy to follow manner. Moreover, it creates a summary with all the indexed tables and clicking one’s name takes you to that specific entry. It’s a nice feature to have for documents which contain a large number of tables.

Since clearly presented information is key, SQL Data Dictionary also comes with a built-in description editor that allows you to add details about tables, columns, indexes, views, procedures and functions.

To wrap it up, though small in stature, SQL Data Dictionary is a reliable tool that can be used to summarize views, stored procedures and functions, as well as to obtain information about data types and primary keys.