SQL Data Dictionary 220.127.116.11
Easy to install and connect to a server
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.
Create your data dictionary in three steps
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.
A practical description editor
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.
Simple, straightforward, handy
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.
Reviewed by Alexandru Chirila on May 23rd, 2014
In a hurry? Add it to your Download Basket!
- Fixed compatibility issue with SQL Server 2005
- HTML output in addition to PDF option
- Automatic saving of last database connection (minus any password)
- Added prompt to view output after creation
Application descriptionSQL Data Dictionary is an application that can help you to quickly and easily generate documentation from a SQL Server...