dean.reynolds_at_home.net wrote:
>
> 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...
> >
> >
> >
Or do it natively in 8i...
--
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."
Received on Sun Mar 28 1999 - 19:43:40 CST
