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.

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.