Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Are the Triggers, Constraints .... getting killed too ??
In article <01be31a5$d2a5d200$LocalHost_at_viao1.camk.com>, Andy Hardy
<aph_at_ahardy.demon.co.uk> writes
>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
>
Only thing that will stay are any synonyms owned by other users that
refer to the table but the grants will disappear.
Pain in the **** isn't it?
>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
>>
>>
>>
>>
>>
>>
>>
--
Diane
Received on Tue Dec 29 1998 - 14:35:18 CST