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 IBM DB2
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.
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: |
|
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: |
|