Modify table: How to change 'Allow Nulls' attribute from not null to allow null?

Question

How to change one attribute in a table using T-SQL to allow nulls (not null --> null)? Alter table maybe?

Answer 1

Yes, by altering the table and altering the specific column. Change the Not Null property on the column to Null or simply remove Not Null reference. E.g. both of these would work:

alter table CourseSchedule

alter column CourseId int

OR

alter table CourseSchedule

alter column CourseId int NULL

Keep in mind, if you were doing the reverse, changing poperty from null to NOT NULL, you would need to first check data and make sure there are no records with nulls in the column.