SQL is neither the ... that corresponds to the Persons primary key, and to preserve relational integrity that field should have a foreign key constraint. For example: CREATE TABLE Orders ( OrderID ...

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.