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

User · Answer

Reference  https   www tutorialspoint com How-can-we-remove-NOT-NULL-constraint-from-a-column-of-an-existing-MySQL-table  ALTER TABLE tableName MODIFY columnName columnType NULL

User · Answer

Remove constraint not null to null  ALTER TABLE  test  CHANGE COLUMN  testColumn   testColumn  datatype NULL

User · Answer

ALTER TABLE YourTable ALTER COLUMN YourColumn columnType NULL

User · Answer

Remove column constraint  not null to null  ALTER TABLE test ALTER COLUMN column 01 DROP NOT NULL

[sql-server] How to remove not null constraint in sql server using query

Examples related to sql-server

Examples related to sql