Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.


  • Hi,

    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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.