"Cannot add column '%3' with 'not null' constraint on table %2 with data. %1"
| Item |
Description |
|
SQLCode
|
-1000062L
|
|
Constant
|
EMSG_TABLEHASDATA
|
|
SQLState
|
QDC35
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20722
|
|
Severity Code
|
14
|
|
Parameter 1
|
location of the exception
|
|
Parameter 2
|
table name
|
|
Parameter 3
|
column name
|
Probable cause
The user tried to ALTER ADD a NOT NULL column to a table that has data. The newly added column would violate the NOT NULL constraint as it would have null data.