Introduction to ALTER TABLE…DISABLE TRIGGER statement

To disable a trigger, you use theALTER TABLE...DISABLE TRIGGER statement.

When you disable a trigger, it remains in the database but won’t activate when an event associated with the trigger occurs.

Here’s the basic syntax of theALTER TABLE...DISABLE TRIGGER statement:

ALTER TABLE table_nameDISABLE TRIGGER trigger_name | ALL

In this syntax,

• First, specify the name of the table to which the trigger belongs after theALTER TABLE keywords.
• Second, specify the name of the trigger you want to disable after theDISABLE TRIGGER keywords, or use theALL keyword to disable all triggers associated with the table.

Suppose you want to disable the trigger associated with theemployees table, you can use the following statement:

ALTER TABLE employeesDISABLE TRIGGER log_last_name_changes;

To disable all triggers associated with theemployees table, you use the following statement:

ALTER TABLE employeesDISABLE TRIGGER ALL;

Summary

• Use theALTER TABLE ... DISABLE TRIGGER statement to disable a trigger or all triggers associated with a table.

Last updated onMarch 26, 2024

On this page

• Introduction to ALTER TABLE…DISABLE TRIGGER statement
• Summary