Altering a column from Not NULL to NULL in SQL server

 Need to alter a table to allow NULL on a column. Not required to drop the column

Please use below script in SQL server.

ALTER TABLE tableName ALTER COLUMN columnname varchar(50) NULL

Please go through details of NOT NULL constraint

• Not Null Constraint