Toad World® Forums

Trigger and dropping table Teamcoding

Hi,

if you drop a table with a trigger attached, the table is removed from TeamCoding and VCS, the trigger however stays in TeamCoding and also in VCS. Better is to get at least a message that there is also a trigger, or that TOAD this also handles well.

Thanks

Herald ten Dam

It seems to me that if you drop a table with the cascade constraints option then TC could abide, dropping constraints and indexes from TC as well (and VCS if the option is on). Good ER.

Just so you know, whenever you click “OK” to the TC Admin window, TC reconciles all of its objects to the DB and removes objects no longer found in the DB. So a good work around would be just to open the TC Admin window and click OK (given that you’ve got TC Admin privileges). However, this will not remove objects from VCS (another good ER if the options is checked to remove from VCS).

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Thursday, January 28, 2016 2:50 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Trigger and dropping table Teamcoding

Trigger and dropping table Teamcoding

Thread created by herald.ten.dam

Hi,

if you drop a table with a trigger attached, the table is removed from TeamCoding and VCS, the trigger however stays in TeamCoding and also in VCS. Better is to get at least a message that there is also a trigger, or that TOAD this also handles well.

Thanks

Herald ten Dam

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.