From daemon Wed Jan 17 01:34:28 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA07937; Wed, 17 Jan 1996 01:34:25 -0500 Message-Id: <9601170634.AA07937@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 9901; Wed, 17 Jan 96 01:15:51 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 8829; Wed, 17 Jan 1996 01:15:46 -0500 Date: Tue, 16 Jan 1996 21:14:52 EST Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Justin Lane X-To: gregory.j.martin@medtronic.com X-Cc: ORACLE-L@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L Subject: (no subject) 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