## • IS_GRANTABLE 

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’ . 

## Notes 

## • TABLE_PRIVILEGES  is a nonstandard INFORMATION_SCHEMA  table. 

The following statements are not  equivalent: 

SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES SHOW GRANTS ... 

## 26.3.45 The INFORMATION_SCHEMA TRIGGERS Table 

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: 

## • TRIGGER_CATALOG 

The name of the catalog to which the trigger belongs. This value is always def . 

## • TRIGGER_SCHEMA 

The name of the schema (database) to which the trigger belongs. 

## • TRIGGER_NAME 

The name of the trigger. 

## • EVENT_MANIPULATION 

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). 

## • EVENT_OBJECT_CATALOG , EVENT_OBJECT_SCHEMA , and EVENT_OBJECT_TABLE 

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 . 

## • ACTION_ORDER 

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. 

## • ACTION_CONDITION 

This value is always NULL . 

## • ACTION_STATEMENT 

The trigger body; that is, the statement executed when the trigger activates. This text uses UTF-8 encoding. 

