Error 1702



Message text

%s failed because definition of column ’%.*s’ in table ’%.*s’ exceeds the limit of %d columns per table. 


This error occurs when you try to create a table with more than the allowed number of columns. The maximum number of definable columns per table is 250 in version 12.0.x and earlier, and 1024 in version 12.5 and later (254 for variable width all-pages-locked (APL) tables).

Note Column names must follow the rules for identifiers. They must be unique within a given table, but you can use the same column name in different tables in the same database.


Reduce the number of columns in the table you are trying to create to or less than the limit. Refer to “create table” in the Reference Manual: Commands for details.

Versions in which this error is raised

All versions