Skip to content

Instantly share code, notes, and snippets.

View sns-seb's full-sized avatar

Sébastien Lesaint sns-seb

View GitHub Profile
-- ##oracle
create TABLE TEST_SEB (
COL_1 varchar(10),
COL_2 varchar(10) NOT NULL
)
-- do not change nullity nor type
ALTER TABLE TEST_SEB MODIFY (
COL_1 varchar(10) NULL,
COL_2 varchar(10) NOT NULL
);
-- ##postgre
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 TYPE varchar(10),
ALTER COLUMN COL_1 DROP NOT NULL,