Foreign key breaks if related unique index is modified

Given:

• A table with a unique index on one or more columns

• A foreign key constraint on one of those indexed columns

Then:

If the unique index is modified (i.e. dropped and recreated) then the foreign key will no longer be valid.

Resolution:

If a unique index is modified, then any foreign keys related to the indexed columns should also be recreated.