Previous Topic Next topic Print topic


WCRT021: Cannot undo the Drop designation for this primary key index due to the existence of another primary key specification.

An attempt was made to remove a Drop designation for a primary key index. However, another primary key index has been specified for this table. Since allowing this operation would yield more than one primary key for the table, and only one is allowed per table, this is illegal.

In order to allow this operation to succeed, you must first either delete (i.e. drop) the other (and newly specified) primary key index, or alter the type of the other primary key index from being a primary key to either a regular index or unique index.

Previous Topic Next topic Print topic