Data Dictionary

Source:Data Dictionary - SQL Server 2012

 Table – right click – Properties – Extended Properties

Thats tells Table description I.e Data Dictionary

DatabaseDesign 4 - Creating a Data Dictionary

New Database Diagram – good( this does not do physical
change)

SQL Server 2012 create relationships and ER diagram

Howto Create a Database Diagram Using SQL Server Management Studio