The INFORMATION_SCHEMA TRIGGERS Table • IS_GRANTABLE Notes 26.3.45 The INFORMATION_SCHEMA TRIGGERS Table • ACTION_STATEMENT • ACTION_CONDITION • ACTION_ORDER • EVENT_OBJECT_CATALOG ,  EVENT_OBJECT_SCHEMA , and  EVENT_OBJECT_TABLE • EVENT_MANIPULATION • TRIGGER_NAME • TRIGGER_CATALOG • TRIGGER_SCHEMA YES  if the user has the  GRANT OPTION  privilege,  NO  otherwise. The output does not list  GRANT OPTION as a separate row with  PRIVILEGE_TYPE=’GRANT OPTION’ . • TABLE_PRIVILEGES  is a nonstandard  INFORMATION_SCHEMA  table. The following statements are  not  equivalent: SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES SHOW GRANTS ... The  TRIGGERS  table provides information about triggers. To see information about a table’s triggers, you must have the  TRIGGER  privilege for the table. The  TRIGGERS  table has these columns: The name of the catalog to which the trigger belongs. This value is always  def . The name of the schema (database) to which the trigger belongs. The name of the trigger. The trigger event. This is the type of operation on the associated table for which the trigger activates. The value is  INSERT  (a row was inserted),  DELETE  (a row was deleted), or  UPDATE  (a row was modified). As noted in Section 25.3, “Using Triggers” , every trigger is associated with exactly one table. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. The  EVENT_OBJECT_CATALOG  value is always  def . The ordinal position of the trigger’s action within the list of triggers on the same table with the same EVENT_MANIPULATION  and  ACTION_TIMING  values. This value is always  NULL . The trigger body; that is, the statement executed when the trigger activates. This text uses UTF-8 encoding. 4833