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 |
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.
