#alter-column

Fixed Altering a column: null to not null #dev #it #asnwer

Altering a column: null to not null

I have a table that has several nullable integer columns. This is undesirable for several reasons, so I am looking to update all nulls to 0 and then set these columns to “NOT NULL.” Aside from changing nulls to 0, data must be preserved.

I am looking for the specific sql syntaxto alter a column (call it ColumnA) to “not null.” Assume the data has been updated…