Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

More columns are being dropped from table '%1' than are defined

Error constant SQLE_TOO_MANY_COLUMNS_DELETED
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the table from which the columns could not be dropped.
Severity 16
SQLCODE –124
SQLSTATE 42W44
Sybase error code 207
Probable cause

The number of columns in a table can never fall below one. Your ALTER TABLE has more drop/delete column clauses than the current number of columns in the table.