Database Description Tool

Free tool for Microsoft SQL Server database documentation
Q: Is the documentation included in a database backup?
A: Yes. The documentation is a part of the database, just like any other object in the database.
Q: Where is the documentation stored?
A: The documentation is stored in Extended Properties, and is a part of the database in the sys.sysxprops base table.
Q: If I delete a Description Field will the documentation also be deleted?
A: The documentation will not be deleted if a Description Field is deleted.

When creating a Description Field, a mapping is created between Database Description Tool and the corresponding descriptions in the database. When the Description Field is deleted from Database Description Tool, the mapping is removed, and the descriptions are still in the database. The mapping can be recreated by creating the Description Field again.

The Description Fields does not contain any object descriptions, and are only a functionality for mapping Database Description Tool to the descriptions in the database.
Q: How do I delete Descriptions?
A: Right click on an object and choose to delete the Descriptions:

Q: What is "Mark as Primary" on a Description Field?
A: When a Description Fields is marked as Primary, the object icon will indicate if there are any documentation for that Description Field on that object.

In this screenshot, "Internal Description" is marked as Primary, indicated by a green dot on the icon:



In the tree it is easy to see what objects that has a description in the "Internal Description" Description Field, again indicated by a green dot:

Q: What are the system requirements?
A: .NET Framework 3.5.

Compatible with Microsoft SQL Server 2005 - 2016.
Q: What licensing model is used?
A: Database Description Tool is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

Database Description Tool is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

https://www.gnu.org/licenses/gpl-3.0.en.html