GitHub

alter table support multiple columns

def test_alter_table_add_two_column(): ddl = """ CREATE TABLE material_attachments ( material_id int NOT NULL, attachment_id int NOT NULL ); ALTER TABLE material_attachments ADD column_name1 ...
GitHub

ALTER TABLE ADD with long column name removes similar column after disconnect

If I then (using the H2 Database Engine's app web interface) add a column with ALTER TABLE Artikel ADD needsHeightMicroMeter INT;, everything looks normal and both the old and the newly added column ...