The FOREIGN KEY constraint, created at the same time as the rest of the table, assures that SQL Server performs the referential integrity checks.