Return
-
Title
Doesn't drop all of the foreign keys -
Description
User created a simple model and the following error occurs when altering it:
Msg 1902, Level 16, State 3, Line 2
Cannot create more than one clustered index on table 'T'. Drop the existing clustered index 'PK_T' before creating another.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. -
Cause
There was an additional foreign key constraint that was created in the email field in the T table.
-
Resolution
Remove the field, then put it back in without a FK and the script should work fine.