The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Is it possible to specify column position when using "alter table add column"?

Is it possible to specify the position of a new column when using alter table to add a column? EG. "alter table myfact add column foo after column bar"?


  • Unfortunately, that feature isn't currently available in Vertica. There's not currently an efficient way to re-order columns; you can just specify the order in the SELECT statement.

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.