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

Comments

• colin_loghin ✭

  October 2013

  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.
  

  0
• Soumya_Behera

  October 2013

  What should i give in the Data source field.

  0
• Soumya_Behera

  October 2013

  
  Thanks for replying . Can you please suggest what should i give in data source column ?

  0
• Soumya_Behera

  October 2013

  Thanks . But i was asking for whether in single query we can add more column. Anyway we can do it one by one .

  0