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

You could try doing the "create as select from" statement and leave the column out of your new select list. You will still have the re-create your indexes and constraints, but if you use the "unrecoverable" option of the "create as select from" statement, then the table re-create is very quick as it does not generate redo log information and is not as messy as exporting/dropping/re-creating and importing.

Regards,
Michael

Jonathan Gennick <gennick_at_worldnet.att.net> wrote in article <6gmi1r$9kk_at_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
>
Received on Wed Apr 15 1998 - 05:32:06 CDT