INFORMATION_SCHEMA Table Reference •The effect of collation on  INFORMATION_SCHEMA  comparisons: Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches” The following table summarizes all available  INFORMATION_SCHEMA  tables. For greater detail, see the individual table descriptions. 4772 26.2 INFORMATION_SCHEMA Table Reference Table 26.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or roles for current user or role 8.0.19 APPLICABLE_ROLES Applicable roles for current user 8.0.19 CHARACTER_SETS Available character sets CHECK_CONSTRAINTS Table and column CHECK constraints 8.0.16 COLLATION_CHARACTER_SET_APPLICABILITY Character set applicable to each collation COLLATIONS Collations for each character set COLUMN_PRIVILEGES Privileges defined on columns COLUMN_STATISTICS Histogram statistics for column values COLUMNS Columns in each table COLUMNS_EXTENSIONS Column attributes for primary and secondary storage engines 8.0.21 CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account ENABLED_ROLES Roles enabled within current session 8.0.19 ENGINES Storage engine properties EVENTS Event Manager events FILES Files that store tablespace data INNODB_BUFFER_PAGE Pages in InnoDB buffer pool INNODB_BUFFER_PAGE_LRU LRU ordering of pages in InnoDB buffer pool INNODB_BUFFER_POOL_STATS InnoDB buffer pool statistics