Answers for "alter table add column if not exists not null"

add column if not exists

ALTER TABLE test ADD COLUMN IF NOT EXISTS column_a VARCHAR(255);
ALTER TABLE test MODIFY IF EXISTS column_a VARCHAR(255);

Posted by: Guest on April-15-2021

add new column not null sql server

ALTER TABLE MY_TABLE
ADD STAGE INT NOT NULL
DEFAULT '0';

Posted by: Guest on September-21-2020

Code answers related to "alter table add column if not exists not null"