Foreign key breaks if related unique index is modified

Description

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.

Environment

None
Fixed

Assignee

Seb Duggan

Reporter

Seb Duggan

Labels

None

Accepted

Yes

Fix versions

Affects versions

Priority

High
Configure