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!

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to