How to remove not null constraint in sql server using query

Question

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

Answer 1

 ALTER TABLE YourTable ALTER COLUMN YourColumn NULL

Answer 2

Alter Table "your table" DROP Constraint "your constraint name"