PDA

View Full Version : Table triggers in MySQL Administrator


Sinclair
02-08-2008, 11:49 PM
Hello,
how can i find out if a table have a trigger attached? I can't find a way to list table triggers in MySQL Administrator. I can only find a list of stored procedures... there is no trace of a trigger even in table editor for the table which have the trigger attached...

ralph l mayo
02-09-2008, 12:23 AM
try selecting from information_schema.triggers

Sinclair
02-09-2008, 12:26 AM
Thanks that worked. Isn't there some GUI for viewing and editing triggers?