Icon ENABLE TRIGGERS

Enables all existing triggers on a given table.

Syntax
ENABLE TRIGGERS ON <TableName>

Usage
Use this statement to enable all triggers on a table. If any of the triggers are already enabled, then this statement does nothing for those triggers.

Information Triggers are enabled or disabled on a per-session basis, so this statement only affects the current session.

Examples
-- The following statement enables all triggers on
-- the Customer table

ENABLE TRIGGERS ON "Customer"

Required Privileges
The current user must be granted the ALTER privilege on the specified table in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image