 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » DDL Statements » DISABLE TRIGGER |
DISABLE TRIGGERDisables an existing trigger on a given table.
Syntax
Usage
Use this statement to disable a trigger on a table. If the trigger is already disabled, then this statement does nothing.
Triggers are enabled or disabled on a per-session basis, so this statement only affects the current session.
Examples
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:
Syntax
DISABLE TRIGGER <Name> ON <TableName>
Usage
Use this statement to disable a trigger on a table. If the trigger is already disabled, then this statement does nothing.
Triggers are enabled or disabled on a per-session basis, so this statement only affects the current session.Examples
-- The following statement disables the UpdateNotes trigger DISABLE TRIGGER "UpdateNotes" 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:
| Deviation | Details |
| Extension | This SQL statement is an ElevateDB extension. |
More Support Options
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
