CREATE OR REPLACE TRIGGER <trigger_name>
{BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON <table_name> [REFERENCING NEW AS <new_row_name> OLD AS <old_row_name>] [FOR EACH ROW WHEN (<trigger_condition>)] <trigger_body>
{BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON <table_name> [REFERENCING NEW AS <new_row_name> OLD AS <old_row_name>] [FOR EACH ROW WHEN (<trigger_condition>)] <trigger_body>
CREATE TRIGGER trigger1
AFTER INSERT ON table1
REFERENCING NEW AS newRow
FOR EACH ROW
WHEN (newRow.a <= 10)
BEGIN
INSERT INTO table2 VALUES(:newRow.b, :newRow.a);
END trigger1;
.
RUN;
SHOW ERRORS TRIGGER <trigger_name>;
SELECT trigger_name FROM user_triggers;
SELECT trigger_type, triggering_event, table_name,
referencing_names, trigger_body
FROM user_triggers
WHERE trigger_name = '<trigger_name>';
DROP TRIGGER <trigger_name>;
ALTER TRIGGER <trigger_name> {DISABLE|ENABLE};