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