Subject | Re: [ib-support] changing a column type to not null |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-05-07T13:42:58Z |
>reading the ALTER TABLE ALTER COLUMN command on the langref, I am broughtI have never used this feature myself, but I think you simply have to make
>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.
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