Skip to content
Advertisement

How to remove not null constraint in sql server using query

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

Advertisement

Answer

 ALTER TABLE YourTable ALTER COLUMN YourColumn columnType NULL
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement