In this post, you’ll learn about the error message -631 foreign key name is too long or has too many columns in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-631 foreign key name is too long or has too many columns
Reason for the Error
This code is used to report that the sum of the length attributes of the columns identified in the indicated FOREIGN KEY clause is greater than 254 bytes or the number of columns identified is greater than 64.� The ‘name’ is the constraint name specified in the FOREIGN KEY clause or, if a constraint name was not specified, the first column name specified in the clause
Solution
The table definition must be modified to conform to the system imposed limit of the sum of the length attributes of the columns identified in the PRIMARY KEY clause.