How to remove not null constraint in sql server using query

Viewed 187162

I am trying to remove not null constraint in sql server 2008 without losing data.

4 Answers

Remove column constraint: not null to null

ALTER TABLE test ALTER COLUMN column_01 DROP NOT NULL;
Related