Re: Deleting a column from a table ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 10 Apr 2001 19:42:17 +0800
Message-ID: <3AD2F199.2A4C@yahoo.com>

Hans Rytter wrote:
>
> Hi.
> Is it possible to delete a column from a table, alternatively is it
> possible to alter the name of a column ???
>
> My db is a ver. 7.3 Oracle.
>
> /Hans.

Rename the table and then create a view with the original name minus the offending column...

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Received on Tue Apr 10 2001 - 06:42:17 CDT