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.

SQL Server allows you to define cascading referential ... If a delete statement affects rows in a foreign key table, those values will be set to NULL when the primary key record is deleted.