Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Fwd: Dropping a column from a table]
Hi Kevin,
You couldn't find it because it doesn't exist. Although I think you took the best alternative in creating a new table another alternative to consider is to create a view that doesn't include the column you want dropped.
Jerry
Kevin J. Kirkpatrick wrote:
>
>
>
> ---------------------------------------------------------------
>
> Subject: Dropping a column from a table
> Date: Thu, 02 Jul 1998 08:15:39 -0400
> From: "Kevin J. Kirkpatrick" <kjk_at_hrb.com>
> Organization: HRB Systems, Inc.
> Newsgroups: comp.databases.oracle
>
> I searched everywhere for a way to drop a column from a table but
> couldn't find anything. It would see that you would be able to do it
> with an ALTER TABLE, but there didn't seem to be anything. I devised a
> work around for this problem. Is there another way besides doing this:
>
> This would create a new table minus the column I wanted out:
>
> CREATE TABLE temp_table
> UNRECOVERABLE
> PARALLEL (DEGREE 3)
> AS SELECT name, phone, ssn FROM employee_table;
>
> After that I would drop out employee_table and then recreate it with the
> following:
>
> CREATE TABLE employee_table
> UNRECOVERABLE
> PARALLEL (DEGREE 3)
> AS SELECT * FROM temp_table;
>
> There has got to be an easier way!! Does anyone know it? This worked
> great but I couldn't find any method that explicitly was for this
> dropping columns from a table.
>
> Kevin
--
Jerry Gitomer ICT Group jgitomer_at_ictgroup.com Langhorne PA jgitomer_at_yahoo.com Opinions are mine not those of ICT GroupReceived on Thu Jul 02 1998 - 09:03:00 CDT