Skip to main content

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

  • April 20, 2013
  • 1 reply
  • 14 views
EugeneAbovsky
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"?

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • April 20, 2013
    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.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement