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.

select

SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

where SEQUENCE_OWNER=‘schema owner’

order by length(LAST_NUMBER) desc

[pb_builder]

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