- Go to SQL Server Management Studio
- Object Explorer
- Databases
- Choose and expand your Database.
- Under your database right click on "Database Diagrams" and select "New Database Diagram".
- It will a open a new window. Choose tables to include in the ER-Diagram.
- Wait for it to complete. Done!!