Can you do a foreign key within a single table, though? I've only ever seen foreign key constraints tying a field in one table to a field in another table.

I'm adding a table and subclass table to my DB. (Subclass table = table where the primary key joins to the primary key of another table, to give extra row information to some subset of the rows ...

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is ...