Saturday, August 22, 2020

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

No comments:

Post a Comment