Re: How to check wether Trigger exists or not

[Bob Field]

USE dbname;

SHOW TRIGGERS;

SELECT routine_name, routine_type
FROM information_schema
WHERE routine_schema='dbname';