Breaking News
Home / Sys Admin / Mysql / How to view all triggers in a schema?

How to view all triggers in a schema?

mysql triggersYes, you can view triggers using the INFORMATION_SCHEMA.TRIGGERS table. The following sql list all the triggers in a given schema.



from dba_sequences

where SEQUENCE_OWNER=‘schema owner’

order by length(LAST_NUMBER) desc


Check Also

How to repair table marked as crashed in MySQL?

MySQL is a very common choice for webmasters and is pretty good and stable database. …

Advertisment ad adsense adlogger