We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

EugeneAbovskyEugeneAbovsky
in General Discussion
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

  • [Deleted User][Deleted User]
    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...