SQL Data Dictionary can generate a professional quality PDF, HTML, or XML document of the tables, views, procedures, and functions in your SQL Server database down to the column level details. Includes indexes, foreign and primary keys, and usage by stored procedures and functions. Includes an easy to use description editor to quickly allow you to add additional documentation directly into the database.

SQL Data Dictionary supports generating a dictionary from a SQL Server database. Also compatible with the latest version of Azure SQL Database.

SQL Data Dictionary requires at least .Net Framework version 4.8 to be installed.

v1.8.0 (03/31/2024)





Change Log:

03/31/24

• Version 1.8.0 released.
  
  
• Prevent Object reference not set exceptions when SQL functions reference system tables.
  
  

08/10/23

• Version 1.7.0 released.
  
  
• Prevent non-printable ASCII characters from causing output failures.
  
  

07/03/23

• Version 1.6.0 released.
  
  
• Updated SQL parsing to use latest version of TSQL.Parser.
  
  
• Prevent procedure parameter default value parsing failures from causing output failures.
  
  

09/22/16

• Version 1.5.4 released.
  
  
• Fixed index out of range exception for some scalar functions.
  
  

07/14/16

• Version 1.5.3 released.
  
  
• Fixed null exception for procedures and functions referencing user defined types.
  
  
• Fixed exception for Security Policy references.
  
  
• Improved display for columnstore indexes.
  
  
• Added full support for SQL Server 2016.
  
  

11/26/15

• Version 1.5.2 released.
  
  
• Various output display improvements.
  
  

11/23/15

• Version 1.5.1 released.
  
  
• Fixed display bug in HTML output for trigger references.
  
  

11/22/15

• Version 1.5.0 released.
  
  
• Added functions and procedures to output.
  
  
• Added triggers to output.
  
  
• Added option to put each object on new page in PDF output.
  
  
• Various output display improvements.
  
  

06/18/15

• Version 1.4.1.1 released.
  
  
• Fixed status window from getting stuck open after error message display.
  
  
• Fixed null exception from empty object descriptions.
  
  
• Removed offline databases from database dropdown list during connect.
  
  

05/23/15

• Version 1.4.1 released.
  
  
• Added status messages during output generation.
  
  
• Improved overall UI.
  
  

12/17/14

• Version 1.4.0 released.
  
  
• Added HTML tree output option.
  
  
• Added XML output option.
  
  
• Added option to include current date and time in output.
  
  
• Added object descriptions to Table of Contents section in output.
  
  
• Added view columns to description editor.
  
  
• Various output display improvements.
  
  

09/02/14

• Version 1.3.0 released.
  
  
• Added HTML output option.
  
  
• Fixed display of max length on nvarchar columns.
  
  
• Fixed display order of index columns.
  
  
• Fixed display of index selectivity.
  
  
• Previously used connection settings now carry over when upgrading versions.
  
  

05/28/14

• Version 1.2.2 released.
  
  
• Fixed incompatibility when finding object references in SQL Server 2005.
  
  
• Various performance improvements.
  
  

04/13/14

• First public version 1.2.1 released.