How to Automatically Generate SQL Server Documentation ?
Open source code is the norm for so many developers these days, and unsurprisingly, so is open documentation. From Azure to TypeScript,
public repositories have become a go-to place for sharing samples,
tutorials, and “tips and tricks” so that everyone can learn and
contribute together as a community.
Getting Started
Installing ASP.NET 5 On Windows
Installing ASP.NET 5 On Mac OS X
Installing ASP.NET 5 On Linux
Choosing the Right .NET For You on the Server
Tutorials
Your First ASP.NET 5 Application Using Visual Studio
Your First ASP.NET 5 Application on a Mac
Publish to an Azure Web App using Visual Studio
Conceptual Overview
Introduction to ASP.NET 5
Introducing .NET Core
DNX Overview
Understanding ASP.NET 5 Web Apps
Fundamentals
Working with Static Files
Routing
Configuration
Dependency Injection
Diagnostics
Working with Multiple Environments
OWIN
.NET Execution Environment (DNX)
DNX Overview
Creating a Cross-Platform Console App with DNX
Working with DNX Projects
Using Commands
Publishing and Deployment
Publish to a Docker Image
Client-Side Development
Grunt and Gulp: Task Runners
Manage Client-Side Packages with Bower
Building Beautiful, Responsive Sites with Bootstrap
Knockout.js MVVM Framework
Styling Applications with Less, Sass, and Font Awesome
Security
Enabling authenication using external providers
Account Confirmation and Password Recovery with ASP.NET Identity
Two-factor authenication with SMS using ASP.NET Identity
Data Protection
Extensibility
Writing Middleware 
dbdescis a powerful tool to help you document your databases. It can produce detailed documents describing your databases
Currently dbdesc supports the following databases:
SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014
Microsoft Desktop Engine 2000 (MSDE) and SQL Server Express editions
MySQL 5.0
Oracle 9 and above
Microsoft Access 97 and above
Firebird
با استفاده از کوئری زیر نیز میتوانید نام و Description ستونها و دیتاتایپ و ... آنها را بدست آورید.
SELECT p.name ,p.value ,t.name AS TableName ,c.name AS ColumnName ,c.is_nullable ,c.max_length ,TYPE_NAME(c.system_type_id) FROM sys.tables t JOIN sys.columns c ON t.object_id = c.object_id LEFT JOIN sys.extended_properties p ON p.major_id = t.object_id AND p.minor_id = c.column_id ORDER BY t.name DESC,c.name DESC
جهت بررسی بیشتر و آشنایی با Extended Properties in SQL Server به لینک Towards the Self-Documenting SQL Server Database مراجعه کنید.
PDF Output
It is now easy to generate a PDF listing all tables and views in your database.
Column Level Details
Get column level detail on primary keys, data types, and defaults along with descriptions. Easily find missing indexes and incorrect column definitions.
Dependencies
Document column level table usage by views, stored procedures and functions.
Description Editor
Use the included description editor to add a description to tables, columns, views, stored procedures, and functions quickly and easily.
It is now easy to generate a PDF listing all tables and views in your database.
Column Level Details
Get column level detail on primary keys, data types, and defaults along with descriptions. Easily find missing indexes and incorrect column definitions.
Dependencies
Document column level table usage by views, stored procedures and functions.
Description Editor
Use the included description editor to add a description to tables, columns, views, stored procedures, and functions quickly and easily.
