Search code examples
positionalterinterbase

Is there a way to add a column to a specific position in Interbase

I need to add a new column to an existing table in my database.

The column should be placed in a specific position.

I know this can be done in two separate commands:

ALTER TABLE MYTABLE
ADD MYCOL INTEGER


ALTER TABLE MYTABLE
ALTER MYCOL POSITION 12

But is there a way to do this in just one?

I searched Interbase's documentation and found nothing that refers to this.

Thanks.

Solution

  • This is the correct syntax:

    ALTER TABLE MYTABLE
ADD MYCOL INTEGER,
ALTER COLUMN MYCOL POSITION 12