Re: how to drop a column in a table?

Erin,

Actually, Oracle8i has a DROP COLUMN command. You probably don't want to migrate just to be able to drop one column <g>, so your only choice is as Voornaam suggested do a

INSERT INTO new_table

   SELECT col1, col2, ... , col[n-1] -- everything but the one you drop    FROM old_table;

then drop old_table and

RENAME new_table TO old_TABLE;

Hope this helps

Klaus Sonnenleiter
The Media Machine, LLC

Voornaam Achternaam wrote:

> There is no single command to drop a column. You'd have to unload the date,
> recreate the table without the column(s) you want to drop and reload the
> data.
>
> Good luck
>
> Erin A. O'Neill wrote in message <7jmmor$2i2b$1_at_nnrp9.crl.com>...
> >I would like to drop just a column in a table. What's the syntax for this?
> >
> ...
Received on Sat Jun 12 1999 - 01:02:02 CEST