How to remove not null constraint in sql server using query

Question

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

Answer 1

Use the below query:

ALTER TABLE YourTable ALTER COLUMN YourColumn columnType NULL