I am trying to remove not null constraint in sql server 2008 without losing data.
This question is related to
sql-server
sql
Remove column constraint: not null
to null
ALTER TABLE test ALTER COLUMN column_01 DROP NOT NULL;
ALTER TABLE tableName MODIFY columnName columnType NULL;
Remove constraint not null
to null
ALTER TABLE 'test' CHANGE COLUMN 'testColumn' 'testColumn' datatype NULL;
Source: Stackoverflow.com