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

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

Comments

  • 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
Emoji
Image
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.