Re: Deleting columns

Depends on the version of the database. If you're on 8i you can alter table X
drop column Y;

Cheryl McIlveen <cmmcilveen_at_home.com> wrote in message news:3A89F537.DBB9A6D_at_home.com...
> Hi all,
>
> Background:
> I am new to Oracle SQL PLUS, and we are using it within a UNIX
> enviornment.
>
> Question:
> I am writing a script using VI and have added a new column to an
> existing table, and made this the Primary Key. What I would like to do
> though is, to be able to delete this new column so I can rerun the
> script without getting the message, that the column already exists. Do I
> need to drop the entire table and create it again at the beginning of my
> script, just to delete one column, or does anyone know of a command that
> will help to this.
>
> Any Help appreciated,
> Cheryl McIlveen
>
>
Received on Sat Feb 17 2001 - 13:12:28 CET