Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Drop column from a table
No, you cant. Oracle 8i is the first Oracle version which supports a drop
column. The tool Hora 4 can do the job for you for an Oracle 7 database. See
www.keeptool.com for a free 30 days trial version of Hora 4.
regards Jan Dieckmann
JMH <JMH_at_badlands.com> wrote in message
news:85oa2u$e81$1_at_bob.news.rcn.net...
> I'm using Oracle 7.3.4 and have decided to move two columns from one
> table to another table. I would have thought I could just do an ALTER
> command but that doesn't seem to work and I cannot find any example
> for check my syntax. Here's the statement:
>
> alter table T drop column C
>
> I also tried without teh "column" bit but got the same results.
>
> Can I drop a column from table?
>
> JMH
>
>
Received on Fri Jan 21 2000 - 09:37:07 CST
![]() |
![]() |