Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR 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}")
 
PREVIOUS NEXT
Tagged: #triggers #query
ADD COMMENT
Topic
Name
4+4 =