Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1
Item |
Value |
|---|---|
SQLCode |
-1000063 |
Constant |
EMSG_COLUMNHASNULLDATA |
SQLState |
QDC34 |
ODBC State |
ERROR |
The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data in it. First delete the null rows before altering the column to enforce the NOT NULL constraint.