> > 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
