Understanding How to Delete Two Primary Keys by Reference Using Cascading Deletes and Transactions in SQL.

Understanding the Impact of Altering a Table: Performance Considerations and Best Practices for Making an Identity Column Primary Key