How do i add multiple column in the existing table . Please share me the syntax to add multiple colu
+1How do i add multiple column in the existing table . Please share me the syntax to add multiple colu
+2Soumya,
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
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.
+1What should i give in the Data source field.
+1
Thanks for replying . Can you please suggest what should i give in data source column ?
+1Thanks . But i was asking for whether in single query we can add more column. Anyway we can do it one by one .
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
