New answers tagged alter-table
Disable any FKs pointing to the table Create table SAVE as SELECT * FROM A Truncate table A Begin to create a script with the following with xfer as (select cast ('a' as text) as targ_tab, cast ('b' as text) as from_tab) select xfer.*, tabs.table_name as targ_table_name, cols.table_name as from_table_name, 'alter table ' || tabs.table_name || ' add (' ...
It works for me. The H2 change log says it was added in version 1.3.171. Here is the original bug alter table credentials add column domain VARCHAR(255) after credentialType; What didn't work for me was having multiple adds inside one alter.
Top 50 recent answers are included