Tag Info

New answers tagged

1

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 (' ...


0

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