O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required