Hi everyone,

I copied a table structure and unfortunately I have
many columns I dont need.

I cant do each alter/drop seperately (see below), is there
a simpler technique to delete columns (wildcard, etc??)

Any Ideas

thanks

George
--------------------------------------------

alter table george_trx
drop column GLOBAL_ATTRIBUTE1;
alter table george_trx
drop column GLOBAL_ATTRIBUTE2;
alter table george_trx
drop column GLOBAL_ATTRIBUTE3;
alter table george_trx
drop column GLOBAL_ATTRIBUTE4;
alter table george_trx
drop column GLOBAL_ATTRIBUTE5;
alter table george_trx
drop column GLOBAL_ATTRIBUTE6;
alter table george_trx
drop column GLOBAL_ATTRIBUTE7;
alter table george_trx
drop column GLOBAL_ATTRIBUTE8;
alter table george_trx
drop column GLOBAL_ATTRIBUTE9;
alter table george_trx
drop column GLOBAL_ATTRIBUTE10;
alter table george_trx
drop column GLOBAL_ATTRIBUTE11;
alter table george_trx
drop column GLOBAL_ATTRIBUTE12;
alter table george_trx
drop column GLOBAL_ATTRIBUTE13;
alter table george_trx
drop column GLOBAL_ATTRIBUTE14;
alter table george_trx
drop column GLOBAL_ATTRIBUTE15;
alter table george_trx
drop column GLOBAL_ATTRIBUTE16;
alter table george_trx
drop column GLOBAL_ATTRIBUTE17;
alter table george_trx
drop column GLOBAL_ATTRIBUTE18;
alter table george_trx
drop column GLOBAL_ATTRIBUTE19;
/
Oracle LazyDBA home page