Home -> Usenet -> comp.databases.oracle -> Deleting columns

Deleting columns

From: Cheryl McIlveen <cmmcilveen_at_home.com>
Date: Sat, 17 Feb 2001 03:03:51 GMT
Message-ID: <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 - 04:03:51 CET












Original text of this message