Foreign Keys and Schema Changes: The Constraint You Didn’t Plan For

You added a foreign key constraint when you designed the schema, verified referential integrity, and moved on. Two years later, you need to modify a column on the child table.