Re: How to delete column

Oracle needs to add this feature, I know there are utilities out there to do this.
In the mean time,

  create new_table
   as (select field1, field2, ..., fieldN);

• leaving out the field you dont want. verify the new table
• drop the old one. copy the new back to the old tablename or
• I think there is a rename command. Recreate you indexes,
• synonyms, grants if needed. Drop the new table if you
• used the copy method.

Marc Lodico
mlodico_at_bigfoot.com

spadesmania rules wrote:

> I accidentally add a column in a table. How do I delete it ?
> Thanks for any help.
Received on Thu Jan 15 1998 - 00:00:00 CET