iAnywhere.com - More columns are being dropped from table '%1' than are defined

SQL Anywhere® 10 - Error Messages > Database Error Messages > Alphabetic list of error messages

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

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