SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Extended properties editors for SQL Server
List of tools that allow editing of SQL Server extended properties .
Direct - read and save extended properties from SQL Server database.
Repository - edit metadata in separate repository and enable synchronization.
Custom fields - whether tool enables editing custom extended properties, apart MS_Description.
Redgate SQL Doc
Redgate SQL Doc is a simple tool for describing and generating documentation of SQL Server. For each object, it displays the text that is stored in the MS_Description extended property in your SQL Server database. For tables, you can edit descriptions for columns, indexes, triggers, and constraints; for views, you can edit descriptions for columns, indexes, and triggers. Object lists and database summaries also include editable description data.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Custom fields |
| Commercial: | Commercial |
| Free edition: |
|
ApexSQL Doc
ApexSQL Doc, a SQL Server documentation tool, displays descriptions for SQL database objects using the extended properties that are stored in the SQL Server database. The Extended property editor feature allows you to add or edit your database object descriptions using the extended properties that are stored in your SQL Server database.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Custom fields |
| Commercial: | Commercial |
| Free edition: |
|
dbdesc
dbdesc is a powerful tool to help you document your databases. It can produce detailed documents describing your databases. It has a built-in extended property editor and documentation exporter.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
Elasoft SqlSpec (discontinued)
SqlSpec is a database documentation tool that will generate easy-to-read database documentation for almost all platforms. It has both GUI and command line interface. It enables you to generate entity-relation diagrams.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
Leadum DBScribe
DBScribe is a SQL documentation tool that automatically creates comprehensive technical documentation of every detail of your database schema. DBScribe SQL documentation tool helps prevent from long routing documenting work and synchronization with database changes, enabling to perform precise database documentation. DBscribe enables you to edit descriptions saved in extended properties in SQL Server.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
DTM Schema Reporter
DTM Schema Reporter is a documenting tool for database schema. This utility helps technical writers, developers, and database administrators create a database schema report within seconds. With DTM Schema Reporter the user can analyze and audit database structure, create schema documentation, train your employees, create a hard copy of the structure snapshots, etc.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
xSQL Documenter
xSQL Documenter provides comprehensive, uniform, and easily navigable database documentation in HTML and compiled CHM format. xSQL Documenter allows you to edit extended properties on a live server from the generated documentation. It provides the ability to define your own extended properties on columns, indexes, triggers, parameters, etc that appear integrated into the documentation.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Custom fields |
| Commercial: | Commercial |
| Free edition: |
|
TechWriter for Databases
TechWriter for Databases is a documentation tool for databases that leverages the information locked inside your database to automatically produce database reference documentation for Access, MySQL, Oracle, SAS, SQL Server, PostgreSQL and DB2 databases.
| Generate documentation: |
|
|---|---|
| Type: | Repository |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
DBMaster
DBMaster is a effective database management tool that helps to automate every day SQL Server administration tasks, highlight database issues, generate custom reports and share information between all team members.
| Generate documentation: |
|
|---|---|
| Type: | Repository |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
Data Dictionary Creator (discontinued)
Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Just MS_Description |
| Commercial: | Free |
| Free edition: |
|
SQL Data Dictionary
SQL Data Dictionary is an easy to use tool to generate a PDF or HTML listing of all tables and views in your SQL Server database. It includes an easy to use description editor to quickly allow you to add additional documentation directly into the database. It provides column level detail on SQL Server primary keys, data types, and defaults along with descriptions.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Just MS_Description |
| Commercial: | Commercial |
| Free edition: |
|
EZ Data Dictionary
EZ Data Dictionary is a user-friendly data dictionary tool for business and technical end users. Documenting database through EZ Data Dictionary provides better results as compared with Excel. It allows users to review database elements and definitions in a friendly environment and provides better communication between systems professionals and end-users.
| Generate documentation: |
|
|---|---|
| Type: | Direct |
| Extended properties: | Custom fields |
| Commercial: | Commercial |
| Free edition: |
|
GenMyModel
GenMyModel supports the edition and generation of database properties. For each object, it displays all attribute fields and allows for extended property edition. For tables, you can edit descriptions for columns, indexes, triggers, and constraints;
for views, you can edit descriptions for columns, indexes, and triggers. Object lists and database summaries also include editable description data. It can be customized without a single line of code.
| Generate documentation: |
|
|---|---|
| Type: | Repository |
| Extended properties: | - |
| Commercial: | Commercial |
| Free edition: |
|