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

Soumya_Behera

colin_loghin

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.

Soumya_Behera

What should i give in the Data source field.

Soumya_Behera

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

Soumya_Behera

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