DB2 Error Code – -624 table table name already has a primary key

In this post, you’ll learn about the error message -624 table table name already has a primary key in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-624 table table name already has a primary key

Reason for the Error

The code is used to report that a primary key cannot be defined in an ALTER TABLE statement because the indicated table already has a primary key.

Solution

A table cannot have more than one primary key.