alter table, drop column error- syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

[Vishi]

Hi everyone, I am using LO Base, Firebird.

I am trying to drop the column is_in_collection from the table samples. However, when running the following query:

ALTER TABLE “samples” DROP “is_in_collection”;

I get the error below:

1: firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE samples failed
*column is_in_collection does not exist in table/view samples
caused by
‘ALTER TABLE “samples” DROP “is_in_collection”’

[keme]

Could it be that the separators in the field name are hyphens or spaces? Double L mismatch? Addressing the wrong table (similar names)?

[Ratslinger]

Another item to check is for an inadvertent space(s) at the end of the field name. Hard to discern but have seen it happen in another post.