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 ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
