Re: Tool to drop Columns

On Wed, 15 Oct 1997 15:03:43 GMT, "Dan Clamage" <clamage_at_mime.dw.lucent.com> wrote:

>Why not just do
>1) CREATE new_table AS SELECT col1, col3, colN FROM old_table;
>2) DROP TABLE old_table;
>3) RENAME new_table TO old_table;
>
>Be sure to backup first.
>- Dan Clamage
>
>Bill Smith <bill_at_frameworkinc.com> wrote in article
><3443834F.275D82AA_at_frameworkinc.com>...
>> Does anyone have, or know of a tool or utility that enables you to
>> easily drop column(s) from an oracle table?

Dan -

It's easier said than done when you'd got a huge load of foreign-key constraints that need to be dropped and recreated! We've started to convert unwanted columns to raw(1), just to show it isn't used.

Why doesn't Oracle just offer an "alter table drop column" option?

Martin Received on Wed Dec 17 1997 - 00:00:00 CET