Custom Search
Reply to comment
Sat, 06/18/2011 - 06:05
SQL CODE -625 while creating primary key
I was trying to create a new primary key on a table by dropping the existing primary key. I got the sql code of -625, when I tried to create the new primary key and the error message read as
SQLCODE = -625, ERROR: TABLE Tablename DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY
Do I need to define a Unique index on the table for the new primary key ?
Reply
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!