Drop 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, SAP ASE drops any triggers associated with it. drop trigger permission defaults to the trigger table owner cannot be transferred.