SQL

get triggers by query

QUERY = "SELECT  event_object_table AS table_name ,trigger_name
          FROM information_schema.triggers
          GROUP BY table_name , trigger_name
          ORDER BY table_name ,trigger_name"

triggers = ActiveRecord::Base.connection.execute("#{QUERY}")