Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- List all triggers in the current database SHOW TRIGGERS; -- List triggers for a specific table SHOW TRIGGERS LIKE 'orders'; -- Drop a trigger DROP TRIGGER IF EXISTS after_order_delete; -- View trigger definition SELECT TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA = DATABASE();
Result
Open