This content has been marked as final. Show 4 replies
Possibly you have a unique index on the columns. Otherwise can you confirm that you are looking in ITS schema.
Thanks. Yes, deleting the index fixes it. But is the index of a unique constraint not supposed to be deleted when the correspoding unique constraint is deleted ?
I just try adding/dropping the constraints and find the indexes are added/dropped automatically, too.
It deopends on whether or not the index was created when the constraint was created.1 person found this helpful
eg if you create a unique index on one or more column and then create a unique constraint on those columns, then the constraint will use the existing unique index.
in this case, when you drop the constraint the index will remain.
However if you do not have a unique index on your column(s) when you created the constraint, then when you create the constraint a unique index is also created.
In this case, when you drop your constraint, the index will also be dropped.
Thanks Keith !!!!!!