allow null in sql server modify column code example
Example: Change A filed to not null
ALTER TABLE
clients
ALTER COLUMN
phone
NVARCHAR(20) NOT NULL;
ALTER TABLE
clients
ALTER COLUMN
phone
NVARCHAR(20) NOT NULL;