I'd like to have the possibility to add column at a given offset.

Currently it's possible to add column at the end of a table. When working with big tables, If someone wants to add a column in a specific position the task becomes really uncomfortable due to the limited sintax of "add column". In fact one should create a mirror table with the entire content, drop and recreate the new table with the new columns and then copy from the mirror table the old data to the new structure. a statement like: ALTER TABLE x ADD COLUMN (desc varchar) AT 5 to add a column with column order 5 would be very nice.


  • Options

    Currently we do not support such functionality to add column at any position in table.
    There is an enhancement feature request for the same, so it may come in future, but no timelines have been defined as of now.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file