alter_column_h2.sql

-- ##H2
create TABLE TEST_SEB (
  COL_1 varchar(10),
  COL_2 varchar(10) NOT NULL
)
-- do not change nullity nor type
alter table TEST_SEB ALTER COLUMN COL_1 varchar(10) NULL;
alter table TEST_SEB ALTER COLUMN COL_2 varchar(10) NOT NULL;

-- change nullity
alter table TEST_SEB ALTER COLUMN COL_1 varchar(10) NOT NULL;
alter table TEST_SEB ALTER COLUMN COL_2 varchar(10) NULL;

-- change type
alter table TEST_SEB ALTER COLUMN COL_1 varchar(20) NOT NULL;
alter table TEST_SEB ALTER COLUMN COL_2 varchar(20) NULL;

-- change type and nullity
alter table TEST_SEB ALTER COLUMN COL_1 varchar(30) NULL;
alter table TEST_SEB ALTER COLUMN COL_2 varchar(30) NOT NULL;