Re: ALTER TABLE DROP COLUMN ?

From: John Claxton <claxtojr_at_email.usps.gov>
Date: 1996/01/29
Message-ID: <4eihlk$r57_at_blue.usps.gov>#1/1

qwerty_at_chiara.dei.unipd.it (Luigi Scappin 264462/IL) wrote:
>Hi.
>I'm loking for an Oracle SQL statement to DROP a COLUMN in a database table.
>I think it's a stupid question... but I don't know how... :-)

DROP COLUMN from TABLE ... does not exist in ORACLE (yet ?). Standard procedure is to create a table with the desired column(s), select into it from the current table. Then drop the current table and RENAME the temp table to the current table's name. Received on Mon Jan 29 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: David Schenfeld: "Need PL/SQL code beautifier or emacs mode"
Previous message: AMARENDRA B NETTEM: "Re: ALTER TABLE DROP COLUMN ?"
In reply to Luigi Scappin 264462/IL: "ALTER TABLE DROP COLUMN ?"
Next in thread: Craig S. Mullins: "Re: ALTER TABLE DROP COLUMN ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message