Re: Are the Triggers, Constraints .... getting killed too ??

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 29 Dec 1998 20:00:03 +0800
Message-ID: <3688C443.E83@bhp.com.au>

michael.kurz wrote:
>
> Hai Diane and Zoltan
>
> Thanx for your quick answer !
>
> If I drop the Table and recreate it
> are then the Triggers, Constraints .... getting killed too ??
>
> Or are they still there ??
>
> Happy New Year :-)
>
> Micha

A quick and dirty way so that you do not have to recreate all of your grants/triggers etc is to:

rename original_table to original_table_secret;

create view original_table as
select "all columns except dropped one" from original_table_secret;

HTH
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Tue Dec 29 1998 - 06:00:03 CST