"Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1"
| Item |
Description |
|
SQLCode
|
-1000063L
|
|
Constant
|
EMSG_COLUMNHASNULLDATA
|
|
SQLState
|
QDC34
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20723
|
|
Severity Code
|
14
|
|
Parameter 1
|
location of the exception
|
|
Parameter 2
|
column name
|
Probable cause
The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data. The user has to first delete the null rows before altering the column to enforce the NOT NULL constraint.