How to generate ER diagrams in sqlserver 2008 r2i want to generate er diagrams for all tables could you please help me how can i generate
i tried through google but i m unable to do ....
Advance thanks for reply
1. Open "Microsoft SQL Server Management Studio"
2. Connect your Sql Instance
3. Open the data base
4. Set all he Primary and Foreign keys for your tables.
5. Right click the Database Diagrams
6. Select New Database diagram
7. Add all the tables.