Enable or Disable Triggers
Specifies that trigger_name is enabled or disabled. When a trigger is disabled it is still defined for the table; however, when INSERT, UPDATE, or DELETE statements are executed against the table, the actions in the trigger are not performed until the trigger is re-enabledSyntax:
Enable a specific trigger
ALTER TABLE <table_name> ENABLE TRIGGER <trigger_Name>
Disable a specific trigger
ALTER TABLE <table_name> DISABLE TRIGGER <trigger_Name>
Enable all triggers
ALTER TABLE <table_name> ENABLE TRIGGER ALL
Disable all triggers
ALTER TABLE <table_name> DISABLE TRIGGER ALL
0 Comments:
Post a Comment
<< Home