Answers for "add not null column to existing table"

SQL Alter column to be not null

ALTER TABLE table_name
ALTER COLUMN col_name data_type NOT NULL;

Posted by: Guest on September-07-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 "add not null column to existing table"