Menu
I created a trigger using SQL, how can I see the trigger using MySQL in phpMyadmin?
522
The MySQL SHOW TRIGGERS statement displays all the defined triggers in database tables. The command helps provide details for existing triggers, including the name, event timing, and other details.
To view database level triggers, Login to the server using SQL Server management studio and navigate to the database. Expand the database and navigate to Programmability -> Database Triggers. To view triggers at the server level, Login to Server using SSMS and navigate to Server Objects and then Triggers folder.
The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT.
Click on the 'SQL' tab and enter this query:
SHOW TRIGGERS
select * from information_schema.triggers where trigger_schema = 'your_db'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
