• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. SQL Server Tables and Databas... > Establishing Relationships Between S...

Establishing Relationships Between SQL Server Tables

You can use three methods to create relationships between the tables in your database. The easiest method is to use a database diagram. A database diagram allows you to graphically establish the relationships between the tables in your database. The second method is via the Properties window for a table. Using the Relationships tab of the Properties window, you can easily add, modify, and remove relationships between the tables in your database. Finally, you can establish and maintain relationships using T-SQL code.

Working with Database Diagrams

As mentioned previously, one way that you can establish and maintain relationships between SQL Server tables is to create a database diagram. It is important to understand how to create a database diagram, add tables to it, edit the diagram, and remove tables from the diagram. The sections that follow cover these topics.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint