Re: Deleting Columns in SQL*Plus
From: REIP Jean-Claude <jacari.consultant.noospaamm_at_skynet.be>
Date: 1997/11/01
Message-ID: <63dqto$pht$1_at_news0.skynet.be>#1/1
Date: 1997/11/01
Message-ID: <63dqto$pht$1_at_news0.skynet.be>#1/1
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 :
- This action may interfere of course with indexes, views, .. based on oldtable !
- You need more place to do this.
- 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>...Received on Sat Nov 01 1997 - 00:00:00 CET
>Is there a way to delete a column in SQL*Plus.?
>
>Thank you,
>
>trien