Subject Re: [ib-support] changing a column type to not null
Author Svein Erling Tysvær
>reading the ALTER TABLE ALTER COLUMN command on the langref, I am brought
>into thinking I can change the type of an existing column fron nullable to
>not null.
>
>However, I cannot find no way to put this into practice.

I have never used this feature myself, but I think you simply have to make
sure your column doesn't contain any NULLs - i.e. UPDATE <table> SET
<column> = <value> WHERE <column> IS NULL before attempting to set the
column to NOT NULL.

Set