Re: Tool to drop Columns

In article <CYV5KPAv44Q0Ewpg_at_rwx777.demon.co.uk>,   Steve Haynes <steve_at_rwx777.demon.co.uk> wrote:
>
> In article <3443834F.275D82AA_at_frameworkinc.com>, Bill Smith
> <bill_at_frameworkinc.com> writes
> >Does anyone have, or know of a tool or utility that enables you to
> >easily drop column(s) from an oracle table? Thanks in advance for any
> >information.
> >
> >Bill Smith
> >Framework Inc.
> >
> Nope.
> Drop and recreate the table.
> Steve

If you don't mind losing all of your records. You can create a temporary table as a select of the columns you want to keep, drop the original table and then rename your temporary table to the original's name. This way you don't lose any of the records.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet