Disables all existing triggers on a given table.

Syntax

---

DISABLE TRIGGERS ON <TableName>

Usage

---

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


Examples

---

-- The following statement disables all triggers on
-- the Customer table

DISABLE 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: