Thursday, 20 April 2017

Disable the Triggers Temporarly In Sybase


On SQL Query editor write and execute the following code to Disable the Trigger

SET TEMPORARY OPTION FIRE_TRIGGERS = OFF;

Now do all your INSERT/UPDATE/DELETE HERE that will not fire tiggers




After your work is completed execute the following code to Enable the triggrers.

SET TEMPORARY OPTION FIRE_TRIGGERS = ON;


Et Voila
Pushparaj

No comments: