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


How do i add multiple column in the existing table . Please share me the syntax to add multiple colu — Vertica Forum

How do i add multiple column in the existing table . Please share me the syntax to add multiple colu

Comments

  • Soumya,
    This question can be answered with the SQL reverence manual.
    Adding multiple columns can be run by running adding 1 column repeatedly.

    As per SQL reference / SQL Statements / ALTER TABLE
    CREATE TABLE test6 (a INT);
    ALTER TABLE test6 ADD COLUMN b INT DEFAULT 5 NOT NULL;
    Hope this helps.
  • What should i give in the Data source field.
  • image
    Thanks for replying . Can you please suggest what should i give in data source column ?
  • Thanks . But i was asking for whether in single query we can add more column. Anyway we can do it one by one .

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file