The primary key or Unique constraint cannot be changed while relationships to the existing primary key or Unique constraint are enforced.

You cannot change a tableÆs primary key or unique constraint while other foreign key relationships are still in place. To change a tableÆs primary key or unique constraint, first delete all existing relationships for the table.

For more information, see Delete a Relationship.