Toad World® Forums

using toad to remove chained rows ... how does it handle constraints/triggers?


#1

Toad (9.5.0.31) had detected several tables with chained rows. Before I repair them using Toad, wanted to know if and how Toad handles cascade on delete constraints and triggers?

Will Toad properly disable the constraints and triggers before deleting and inserting the rows back?

thanks for your responses.


#2

I just glanced at the 9.5 source code. I do see code in there to disable
triggers and constraints beforehand and enabled them afterwards.

If you want to see exactly what it does, turn on spool sql (Main menu ->
database -> spool sql -> spool to screen), then try it with a test table. It
will show all of the queries that Toad executes.