Column

Hey,

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

Thanks,

ALTER TABLE tablename MODIFY columnname varchar(50) NULL;

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

Just update the column where it is null:

Code:

---

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

---

Then run mendhak's suggestion.

Thats true
:wave: