Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Disabling triggers [Table of Contents] Getting information about triggers

Transact-SQL User's Guide

[-] Chapter 16 Triggers: Enforcing Referential Integrity
[-] Dropping triggers

Dropping triggers

You can remove a trigger by dropping it or by dropping the trigger table with which it is associated.

The drop trigger syntax is: 

drop trigger [owner.]trigger_name 
     [, [owner.]trigger_name]...

When you drop a table, Adaptive Server drops any triggers associated with it. drop trigger permission defaults to the trigger table owner and is not transferable.

Disabling triggers [Table of Contents] Getting information about triggers