Database Diagrams?

Question

How to draw the database diagrams in sql server,can any one tell me,I need to draw relation ship between tables like,please check the below file

Tuhin Paul · Answer

Follow the steps: Open SSMS and connect to the database for which you want to create a diagram. Expand the database in Object Explorer and navigate to the "Database Diagrams" folder. Right-click the "Database Diagrams" folder and select "New Database Diagram". In the "Add Table" dialog box, select the tables you want to include in the diagram and click "Add". In the diagram, you can drag and drop tables to position them as you want. To create a relationship between two tables, click and drag the primary key column of one table to the foreign key column of the other table. A line will appear between the two tables indicating the relationship. To edit the properties of a table or relationship, right-click it and select "Properties". When you're finished creating the diagram, save it by clicking "Save" on the toolbar.

Rajeev Kumar · Answer

This is composed of entity types (people, places or things). It shows relationships that can exist between them. By defining the entities, their attributes and showing the relationships between them, an ER diagram illustrates the logical structure of databases

Pradeep Shet · Answer

Hi usha, It is simple select the column name and drag it to other table else other option is shown below. Mark it as answered if it helped you.

Database Diagrams?

Answers (3)