
> 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

Fri, 7 May 2004 13:05:07 +0200
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: ALTER TABLE TODO items