Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)

(no subject)

From: Justin Lane <Justin_Lane.ELI_LILLY_AU_at_NOTES.COMPUSERVE.COM>
Date: Tue, 16 Jan 1996 21:14:52 EST
Message-Id: <9601170634.AA07937@alice.jcc.com>


  To drop a column:

create table 'tablename' as select col1, col2... from the original table, selecting only the columns you wish to keep.

You will also need to recreate any table constraints and indexes.

This approach seems a little inelegant, hopefully someone might have a better suggestion.

Justin Lane
Information Architect
Eli Lilly Australia Received on Wed Jan 17 1996 - 01:34:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US