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

asked 2019-11-04 12:33:36 +0100

Vishi gravatar image

updated 2019-11-04 14:00:45 +0100

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"'

edit retag flag offensive close merge delete


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

keme gravatar imagekeme ( 2019-11-04 14:24:13 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2019-11-04 16:48:52 +0100 )edit