How to view a table relationship diagram in SQL Server?

In SQL Server Management Studio, you can view table relationships using the following method:

1. Open SQL Server Management Studio and connect to the database server.
2. Expand the database in “Object Explorer” and locate the database you want to view table relationships for.
3. Right-click on “Database Diagrams” and select “New Database Diagram”.
4. Select the table you want to include in the chart in the pop-up dialog box, and then click “Add.”
5. After adding all the tables, click on “close”.
6. You will see a graphic representation containing the selected table, displaying the relationships between them.
7. You can drag the tables to rearrange them, or drag the arrows between the tables to create connections.
8. Click on the save icon to save the image.

This way, you can view the relationship diagram between tables using SQL Server Management Studio.