Creating Multiple Triggers

Create up to 50 different triggers on a table for each command (insert, update, and delete). Use the new order parameter in the create trigger command, and specify the order that the triggers fire. You can create multiple triggers without an order clause.

The syntax is:
create [or replace] trigger [owner.]trigger_name
    on [owner.]table_name
    for {insert | update | delete}
    [order integer]
    as sql_statements
order integer specifies a partial or full ordering of trigger firing:
Note: You can only use the order integer clause with for {insert | update | delete}; you cannot use it with instead of {insert | update | delete} triggers.

If you use a duplicate number for order, SAP ASE reports an error. order numbers need not be consecutive; in fact, nonconsecutive numbers might be preferable, as they allow you to insert new triggers into the middle of an order.

Use sp_helptrigger to list:
Related concepts
create trigger for Multiple Triggers