A table with a unique index on one or more columns
A foreign key constraint on one of those indexed columns
If the unique index is modified (i.e. dropped and recreated) then the foreign key will no longer be valid.
If a unique index is modified, then any foreign keys related to the indexed columns should also be recreated.