SQL update to allow null values

Question

I have table in MSSQL that has a column where the value can not be null. But there are update operations where i want to set that column to null when i update the other columns. Is there such a way to achieve this , or should i recreate the table , allowing the column to take null values.

Answer 1

You should allow null for your column: alter table T1 alter column C1 int null