db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Douglas Granzotto (Infoarte)" <dgranzo...@infoarte.trix.net>
Subject Re: Plataform.getAlterTablesSql results
Date Wed, 14 Jun 2006 14:47:01 GMT
> 
> This depends on what platform you use. Some databases fully support
> adding columns (e.g. MySQL), for some this can only be used under
> specific conditions, and for some, there is no way of adding the
> column except by re-creating the table as is done in the SQL that you
> posted.
> 
> Tom
> 

I am using Firebird 1.5, and this supports add column.
So much that I removed the unnecessary commands,  
only remaining:

> ALTER TABLE IPI
>     ADD CLASSFISCAL VARCHAR(12);
>
> ALTER TABLE IPI
>     ALTER CLASSFISCAL POSITION 4;

And that's ran ok, the modification was executed with success.

Douglas

Mime
View raw message