Breaking News
Home / Sys Admin / Mysql (page 2)

Mysql

How to view all triggers in a schema?

Yes, 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]

Read More »
Advertisment ad adsense adlogger