Answers for "how to add not null to an existing column"

Change A filed to not null

ALTER TABLE
  clients
ALTER COLUMN
  phone
    NVARCHAR(20) NOT NULL;

Posted by: Guest on March-19-2020

sql not null

SELECT column_name FROM table_name 
WHERE column_name IS NOT NULL;

Posted by: Guest on December-07-2020

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 "how to add not null to an existing column"