How To Create Database Diagram in SQL Server 2005
- Click on Database Diagram on your Database. At the first time Microsft SQL Server Management Studio will alert you a message. And then you click Yes button if you want to creat database Diagram.
- Right Click on Database Diagrams and click on New Database Diagram
- Select on your table name and then click Add button.
- Create Relationship
- Select Primary key and Foreign key. And than click Ok button
- And then click Ok button on form Foreign key Relationship.
- here is your result Relationship.
- Click Save button
- Enter your Diagram name.
