1

Is it possible to add multiple columns to a table in a single query execution, using alter table in exasol?

example:

Alter table Employee add column phone_number varchar(256), add column address varchar(256)

swapna p
  • 83
  • 7

2 Answers2

2

It is not possible in one command in Exasol, but in Exasol DDL commands do not auto-commit, so you can put them in the same transaction. You could do:

 set autocommit off;
 alter table t1 add column c1 varchar(100);
 alter table t1 add column c2 varchar(100);
 alter table t1 add column c3 varchar(100);
 commit;
 set autocommit on;
mucio
  • 7,014
  • 1
  • 21
  • 33
0

No. According to the documentation it is impossible.

GriGrim
  • 2,891
  • 1
  • 19
  • 33