Answers for "how to add column to table that not contain null"

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

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

Code answers related to "how to add column to table that not contain null"