Re: Drop column from a table

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Fri, 21 Jan 2000 16:37:07 +0100
Message-ID: <869uh1$11n1$1@black.news.nacamar.net>

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