Hello Anand,
the syntax diagram at https://www.sqlite.org/lang_altertable.html shows
that an alter table statement for sqlite can contain "add column" only once.
I myself came against that fact when porting my DDL statements from
PostgreSQL to SQLite.
So, the answer is "you can't".
Martin
Am 08.10.2014 10:29, schrieb AnandArun:
ALTER TABLE "main"."tblCredit" ADD COLUMN "CardDetail" VARCHAR;ALTER TABLE
"main"."tblCredit" ADD COLUMN "CardDetail1" VARCHAR;
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/how-to-add-multiple-columns-at-a-time-tp43355p78464.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
