dbForge Documenter for SQL Server is a big time saver when it comes to documenting your SQL Server databases. It automatically generates documentation of an entire SQL Server database in just a few clicks. It also includes a wide range of customization options to meet your specific requirements. The output formats include HTML, PDF, and Markdown.
Getting started with the Documenter add-in for SSMS