Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous

 

 

 

 

 

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

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 714
Theme by Dr. Radut.