-689   TOO MANY COLUMNS DEFINED FOR A DEPENDENT TABLE

Explanation

The maximum number of columns allowed for a dependent table is 749. The code is used to report that the statement is invalid because of one of the following:
  • A CREATE TABLE statement is creating a dependent table with 750 columns.
  • An ALTER TABLE statement is altering a dependent table with 749 columns to add a column, or altering a table with 750 columns to become a dependent table.

System action

The statement cannot be processed.

Programmer response

Correct the SQL statement to conform to the column limit for a dependent table.

SQLSTATE

54011