Re: Drop coloum in Table

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 25 Oct 1999 12:41:58 +0800
Message-ID: <3813DF96.3FFD@yahoo.com>

Garsen Subramoney wrote:
>
> Hi
>
> Is there a quick and easy way of dropping a column in a Table that has
> constraints against it and which has data in it.

You can do it in 8.1.5

before this, just

1. rename the table xxx to xxx_gone
2. create a view xxx on xxx_gone without your column
3. ensure that the column dropped is nullable

Voila
--

---

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 Sun Oct 24 1999 - 23:41:58 CDT