Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Are the Triggers, Constraints .... getting killed too ??

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

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Sun, 27 Dec 1998 14:53:54 GMT
Message-ID: <01be31a5$d2a5d200$LocalHost@viao1.camk.com>


Michael,

If you drop a table then all objects relying on that table are also dropped (or made invalid in the case of packages, views, etc), so yes you are going to loose your triggers, constraints, etc.

Andy

michael.kurz <michael.kurz_at_metronet.de> wrote in article <765bgm$s1b$1_at_news.metronet.de>...
> 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
>
>
>
>
>
>
>
Received on Sun Dec 27 1998 - 08:53:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US