Error 1000062

Message text

Cannot add column with not null constraint on table %2 with data. %1

Item

Value

SQLCode

-1000062

Constant

EMSG_TABLEHASDATA

SQLState

QDC35

ODBC State

ERROR

Parameter 1

location of the exception

Parameter 2

table name

Probable cause

The user tried to alter add a NOT NULL column to a table that has data. The newly added column will violate the not null constraint as it will have null data by default for the newly added column.