Re: how do i drop a column?

rename the table to tmp_TABLENAME

then do a CREATE AS SELECT and only select the columns you want in the new table.

-Dean

On Wed, 24 Mar 1999 15:31:30 +0100, "Dr. Jan Dieckmann" <JDieckmann_at_psi.de> wrote:

>Hi,
>
>with Oracle < 8i it is not possible with a single statement. But ther
>are tools like Hora 3 which make the job (rename the old table, crete a
>new, create the indexes, trigger ...) for you. See
>http//www.keeptool.com for a free trial version of Hora 3.
>regards Jan Dieckmann
>KeepTool GbR
>
>John Matzen wrote:
>
>> i know that has got to be a dumb question, but i have a column in a
>> table and i need to get rid of it...
>
>
>
Received on Thu Mar 25 1999 - 20:46:44 CST