Re: delete col

In article <8fca9l$2ti$1_at_bob.news.rcn.net>,   "ed zappulla" <zappullae_at_rcn.com> wrote:
> Does anyone know how to remove a column from an ora db. 8.0.0.5 and
 8.1.6?
>
>

8.1.5 and up:

alter table T drop column C;

before 8.1, you would:

rename table T to X
create view T as select <all but that column> from X; revoke <whatever> on x
grant <whatever> on T

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.