Re: Deleting Columns in SQL*Plus

No !

If you need it, you can do it by another way :

create table tmp as select col1, col3, col5,... from oldtable; drop table oldtable;
rename tmp to oldtable;

WARNINGS :

1. This action may interfere of course with indexes, views, .. based on oldtable !
2. You need more place to do this.
3. It's time to verify storage clauses !

Hope this helps :-)

--
REIP Jean-Claude
Enlevez ".remove.this" de l'adresse (anti-spam)
jacari.consultant.remove.this_at_skynet.be
Trien Ngoc Nguyen wrote in message <345b54e0.27733250_at_news1.ibm.net>...


>Is there a way to delete a column in SQL*Plus.?

>

>Thank you,

>

>trien