Column

[vbgladiator]

Hey,

Is it possible to change a column's Allow Nulls property after the table has been created?

Thanks,

[mendhak]

ALTER TABLE tablename MODIFY columnname varchar(50) NULL;

[sw_is_great]

This will fail
if
you modify to not allow null
and
the column has already null value

[vb_dba]

Just update the column where it is null:

Update myTable
Set Field1 = 'SomeValue'
Where Field1 Is NULL

Then run mendhak's suggestion.

[sw_is_great]

Thats true