Home

Welcome to the CreateDataDictionary wiki!

Features:

• Creates worksheet for every table within the database
• Each table sheet contains the extended property information for the table and each column in the table
  • Each column also lists the data type, maximum length, and whether or not the column is a part of the key
• A sheet is created "MissingDescriptions" for objects (tables and/or columns) that are missing description extended properties.
  • Each row, when a description is written, also generates a SQL statement that can be used to generate the extended property on the database
• A sheet is created "DbObjects" which describes parameter information for the database's stored procedures and functions.
• Feature to exclude specific tables from the data dictionary. This could be for reasons such as, they are temporary tables, development specific tables, or tables that (somehow) made it into production that shouldn't have gasp

Problems:

• Excel has a limitation of 31 characters for a sheet name. Since sheets are created for every table, if you have a table with a name longer than 31 characters an exception will be thrown. You can get around this by excluding the table either with an update to the config file exclusion list, or any of the ITableExcluder implementations. Bug opened in #7, not sure when I'll be able to get to it.