I think u can club all the columns in one alter like this..... Not sure
though....

ALTER TABLE george_trx
Drop ( GLOBAL_ATTRIBUTE1,GLOBAL_ATTRIBUTE2,GLOBAL_ATTRIBUTE3.......);


Warm regards,
Vikas Bhat

-------------------------------------------------------
Fidelity Investments Systems Company
Embassy Golf Links Business Park,
Off Intermediate Ring Road,
Bangalore 560071
Phone: +91 80 5691 6422
Email: Vikas.[Email Address Removed] Message-----
From: Lewycky, George [mailto:[Email Address Removed]
Sent: Thursday, January 29, 2004 10:58 AM
To: LazyDBA.com Discussion
Subject: simple way to drop numerous columns in a single step ??



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;
/

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page