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 cannot be transferred.
