Re: Drop column from a table

From: Paul Q <paulq_at_home.com>
Date: Fri, 14 Jan 2000 23:37:22 GMT
Message-ID: <SqOf4.43416$g12.1170813@news2.rdc1.on.home.com>

Not in 7.3.4 .. upgrade to 8i

or create new_table as select fields_you_want from old_table

"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 14 2000 - 17:37:22 CST