Re: rename a column

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 27 Jan 2000 22:29:17 +0800
Message-ID: <3890563D.33D8@yahoo.com>

mdawood_at_petratech.net wrote:
>
> How do I rename a column that has no data?
>
> I added the column to a table that has 2 million records. With complex
> FK, and indexes. That is why I do'nt want to drop the table and
> recreating.
>
> ORACLE 8, SQL*PLUS
> TIA,
>
> MD
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Rename the table to something else
Create a view using the original table name and column you want.

It is possible to hack SYS.COL$ but I wouldn't recommend it.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 27 2000 - 08:29:17 CST