Tuesday, 21 July 2015

DATABASE DIAGRAM


Navigation To Create Data Base Diagram

Step1: Open SQL Server Management Studio(SSMS) using admin login(sa) and password(sa123)

Step2: In Object Explorer expand Databasesàexpand your required Database (Sample)àright click on Database DiagramsàNew Database Diagram













Step3: Add your required tables to construct the diagram and click on Close button

Step4: Here we selected DEPT, EMP, PROJECT tables
We will get database diagram in the below format



No comments:

Post a Comment