SHOW TRIGGERS

Go Up to isql Command Reference

Lists all triggers or displays information about a specified trigger.

SHOW {TRIGGERS | TRIGGER name};

Argument	Description
<name>	Name of an existing trigger in the current database

Description: SHOW TRIGGERS displays all triggers defined in the database, along with the table they depend on. SHOW TRIGGER name displays the name, sequence, type, activation status, and definition of the named trigger.

SHOW TRIGGER has a shorthand equivalent, SHOW TRIG.

Deleting a table that has a dependent trigger is not allowed. To avoid an isql error, delete the trigger (using DROP TRIGGER) before deleting the table.

Examples: To list all triggers defined for the current database, enter:

SHOW TRIGGERS;
Table name Trigger name
=========== ============
EMPLOYEE SET_EMP_NO
EMPLOYEE SAVE_SALARY_CHANGE
CUSTOMER SET_CUST_NO
SALES POST_NEW_ORDER

To display information about the SET_CUST_NO trigger, enter:

SHOW TRIG SET_CUST_NO;
Triggers:
SET_CUST_NO, Sequence: 0, Type: BEFORE INSERT, Active
AS
BEGIN
new.cust_no = gen_id(cust_no_gen, 1);
END