How to remove not null constraint in sql server using query
Remove constraint not null
to null
ALTER TABLE 'test' CHANGE COLUMN 'testColumn' 'testColumn' datatype NULL;
ALTER TABLE YourTable ALTER COLUMN YourColumn columnType NULL
Remove constraint not null
to null
ALTER TABLE 'test' CHANGE COLUMN 'testColumn' 'testColumn' datatype NULL;
ALTER TABLE YourTable ALTER COLUMN YourColumn columnType NULL