By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point. Skip ...

When you query SAS tables, relations provide a way to identify rows and to relate (or join) rows in one table to rows in another table. You define a relation on one or more columns in a table.

Across physical tables, shared columns are the evidence of a foreign key relationship. The columns comprising the primary key of the table on the one-side of the relationship are repeated on the table ...