Re: Drop Field

> On 6 Jul 1998 05:36:26 GMT, "Bruger" <Bruger_at_firma.dk> wrote:
>
> >Hi
> >You canīt drop a field name !!! You have to drop and recreate the whole
> >table...
> >
>
> Yeah! Does anyone already know why has Oracle decided that an option
> for dropping a column in the ALTER TABLE command would be useless?
>
> Just curiosity. I've never worked with other major DBMS, I wonder if
> they all think the same way.
>

I've worked with Progress for a while and as far as I can remember it is possible to drop a
field/column in an existing table, provided your database is down of course.

Michiel

--
Michiel Verhoef

phone: (078) 6392585
e-mail: Michiel.Verhoef_at_wkap.nl

Anagram of a piece of Hamlet by Shakespeare:

To be or not to be; that is the question. Whether tis nobler in the mind to suffer the slings and arrows of outrageous fortune." =

In one of the Bard's best-thought-of tragedies, our insistent hero, Hamlet, queries on two fronts about how life turns rotten. Received on Mon Jul 06 1998 - 06:11:03 CDT