Re: ALTER TABLE TODO items

> FireBird: ALTER COLUMN <column> TYPE <type>
> DB2:    ALTER COLUMN <column> SET DATA TYPE <type>.
> Oracle:    MODIFY <column> <type>
> MSSQL:    ALTER COLUMN <column> <type> <constraints>
> MySQL:    Both Oracle and MSSQL
> Sap:    MODIFY <column> <type>
>
> Spec:    Nothing (obvious) on changing column types
>
> MODIFY is horrible. It seems to drop all constraints, defaults, etc that
> are not specified in the second definition. It is essentially a
> replacement of the column.

In Oracle MODIFY leaves omitted parts unchanged,
syntax is actually ALTER TABLE <table> MODIFY (<column> <type> <default> <constraint>)
I think the parentheses are optional if only one column is modified.

Andreas