Extended information about database structure

dbForge Documenter extracts an extensive database info including a wide range of SQL object types, their details, and properties, as well as inter-object dependencies and DDL codes.

The information about the following objects is available in the documentation:

• owners
• descriptions
• properties
• table and view columns
• indexes and constraints
• routine parameters
• creation script
• object dependencies

Rich customization features

Documenter supports a selection of individual database objects and their properties that will be documented. The tool also contains a rich set of style templates as well as allows changing documentation layout using various Bootstrap themes.

Self-documenting SQL objects

The information about most of database objects is extracted from the extended properties of the objects to which these properties are attributed.

The documenter tool allows to modify an object description as well as add it if the object description is not specified.

Formats supported

Documenter generates documents from a database in multiple formats:

• HTML - Hypertext Markup Language file format is suited for databases to be published on the web.
• PDF - Portable Document Format is good for printing and distributing to various systems and devices.
• Markdown - a lightweight markup language with plain text formatting syntax that can be converted to many output formats.

The formats are searchable, which is very convenient especially for large databases.

Searchable documentation

Search across the generated documentation for database objects. As you type the name of a required object in the search field, dbForge SQL Server documentation tool highlights the matching text in the object tree. You can also navigate throughout the documentation via build-in hyperlinks.

SSMS Integration

Documenter integrates seamlessly with Microsoft SQL Server Management Studio as an SSMS add-in.

Launch the database documentation tool directly from the SSMS Object Explorer without closing the environment.