SQL Doc by Red Gate is an interactive and intuitive tool for documenting your SQL Server databases. It quickly creates comprehensive technical documentation for your Microsoft SQL Server databases in HTML, PDF, and Markdown formats. It offers full customizability, allowing you to include only the information you need in your documentation. It can also generate detailed diagrams, including entity relationship diagrams, allowing you to visualize your database structure. Additionally, it can identify dependencies between objects and generate a cross-referenced report of all objects that depend on a certain object. SQL Doc by Red Gate is a great tool for teams, who need to quickly generate comprehensive technical documentation for their databases.
Detailed documentation + have BI and Tableau documentation.