Disable/Enable Triggers

Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]

These actions let you build and submit ALTER TABLE statements that specify ENABLE TRIGGER or DISABLE TRIGGER options.

Platform Availability

• SQL SVR, SYB ASE

To Enable or Disable Triggers for a Table

1. On the Database Navigator/Explorer, select the Tables node.
2. On the Database Navigator/Explorer, right-click one or more selected tables and select Enable Triggers or Disable Triggers.

   The Enable Triggers or Disable Triggers dialog opens, as appropriate.

3. Click Execute.