Re: newbie question: how to delete a column from a table definition

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 11 Apr 1998 01:46:09 GMT
Message-ID: <6gmi1r$9kk@bgtnsc03.worldnet.att.net>

On 10 Apr 1998 07:44:40 GMT, "Steven Cools" <Steven_at_digimap.be> wrote:

> this is a very simple question : how can I delete a column from a table
>definition using PL/SQL? I searched through the manual of PL/SQL but I
>couldn't find it. Why is it not as simple as in Informix/SQL:
>
>alter table TABLENAME
>drop NAME-OF-COLUMN

I think Oracle is the only database on the face of the earth that can't handle this<g>. There is no "DROP COLUMN" command. You have to save the data, drop the table, recreate the table, reload the data, and recreate all constraints & indexes in order to remove the column.

regards,

Jonathan Received on Fri Apr 10 1998 - 20:46:09 CDT