DROP TRIGGER

SQL Guide : solidDB® SQL statements : DROP TRIGGER

DROP TRIGGER

DROP TRIGGER [[catalog_name.]schema_name.]trigger_name

Usage

The DROP TRIGGER statement drops (or deletes) a trigger defined on a table from the system catalog. You must be the owner of a table or have DBA authority to delete a trigger from a table.

Examples: Dropping triggers

DROP TRIGGER update_acct_balance;
-- Using schema and trigger name
DROP TRIGGER savings_accounts.update_acct_balance;
-- Using catalog, schema, and trigger name
DROP TRIGGER accounts.savings_accounts.update_acct_balance;

Example: Dropping and re-creating a trigger

DROP TRIGGER TRIGGER_BI;
COMMIT WORK;

"CREATE TRIGGER TRIGGER_BI ON TRIGGER_TEST
      BEFORE INSERT
      REFERENCING NEW BI AS NEW_BI
BEGIN
      EXEC SQL PREPARE BI INSERT INTO TRIGGER_OUTPUT VALUES(
       ’BI_NEW’, TRIG_NAME(0), TRIG_SCHEMA(0));
      EXEC SQL EXECUTE BI;
      SET NEW_BI = ’TRIGGER_BI_NEW’;
END";
COMMIT WORK;

INSERT INTO TRIGGER_TEST(XX) VALUES (’XX’);
COMMIT WORK;

SELECT * FROM TRIGGER_TEST;
SELECT * FROM TRIGGER_OUTPUT;
COMMIT WORK;