content_image/736950.jpg
WHERE NAME LIKE ’statement/sql/%’ ORDER BY NAME; +---------------------------------------+ | NAME | +---------------------------------------+ | statement/sql/alter_db | | statement/sql/alter_db_upgrade | | statement/sql/alter_event | | statement/sql/alter_function | | statement/sql/alter_instance | | statement/sql/alter_procedure | | statement/sql/alter_server | ... 

A table-access event provides information about specific table accesses. Table 6.33, “Table-Access Event Fields”  indicates the permitted fields for table-access events. 

<img src='content_image/736950.jpg'>

The following list shows which statements produce which table-access events: 

• read  event: 

• SELECT 

• INSERT ... SELECT  (for tables referenced in SELECT  clause) 

• REPLACE ... SELECT  (for tables referenced in SELECT  clause) 

• UPDATE ... WHERE  (for tables referenced in WHERE  clause) 

• HANDLER ... READ 

• delete  event: 

• DELETE 

• TRUNCATE TABLE 

• insert  event: 

• INSERT 

• INSERT ... SELECT  (for table referenced in INSERT  clause) 

• REPLACE 

