ALTER TABLE ... DROP COLUMN IF EXISTS misbehaves?

[Nick99]

Hi,

H2 1.3.157

I'm trying to drop a column /via console/ if it exists:

>ALTER TABLE TEST DROP COLUMN IF EXISTS 'UUID'
>Column "IF" not found; SQL statement:
ALTER TABLE TEST DROP COLUMN IF EXISTS 'UUID' [42122-154] 42S22/42122
(Help)

however, http://www.h2database.com/html/grammar.html?highlight=grammar&search=gramm#alter_table_drop_column
states that "IF EXISTS" is a valid token.

Any help would be appreciated.

Thanks!

[Thomas Mueller]

Hi,

Possibly this was not supported in version 1.3.154. This works in the
current version:

ALTER TABLE TEST DROP COLUMN IF EXISTS UUID;

Please note you can't use single quotes around UUID.

Regards,
Thomas