Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Are the Triggers, Constraints .... getting killed too ??
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