![]() |
SQL-J Language Reference
|
Reference Manual |
SET TRIGGERS statementSET TRIGGERS allows you to disable and to re-enable a specified trigger or triggers, all triggers for a specified table, or all triggers in the database. (Re-enabling a trigger does not cause it to fire on any changes that were made while it was disabled.) Syntax
SET TRIGGERS ALL disables or re-enables all triggers in the database that exist at the time the SET TRIGGERS statement is executed should be disabled or re-enabled. FOR TableName disables or re-enables all triggers on the table that exist at the time the statement is executed. Disabling or re-enabling a trigger is persistent and affects all connections. Example |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |