Chapter 26 INFORMATION_SCHEMA Tables Table of Contents 26.1 Introduction ........................................................................................................................... 4769 26.2 INFORMATION_SCHEMA Table Reference ........................................................................... 4772 26.3 INFORMATION_SCHEMA General Tables ............................................................................. 4776 26.3.1 INFORMATION_SCHEMA General Table Reference ................................................... 4776 26.3.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table .... 4778 26.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table ........................................ 4779 26.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table .......................................... 4780 26.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table .................................... 4780 26.3.6 The INFORMATION_SCHEMA COLLATIONS Table .................................................... 4780 26.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table .................................................................................................................................... 4781 26.3.8 The INFORMATION_SCHEMA COLUMNS Table ........................................................ 4782 26.3.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table ................................. 4784 26.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table ................................... 4785 26.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table .................................... 4786 26.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table .......................................... 4786 26.3.13 The INFORMATION_SCHEMA ENGINES Table ........................................................ 4787 26.3.14 The INFORMATION_SCHEMA EVENTS Table .......................................................... 4788 26.3.15 The INFORMATION_SCHEMA FILES Table .............................................................. 4791 26.3.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table ................................... 4799 26.3.17 The INFORMATION_SCHEMA KEYWORDS Table .................................................... 4801 26.3.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table ................. 4801 26.3.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table ........................................ 4802 26.3.20 The INFORMATION_SCHEMA PARAMETERS Table ................................................ 4803 26.3.21 The INFORMATION_SCHEMA PARTITIONS Table ................................................... 4804 26.3.22 The INFORMATION_SCHEMA PLUGINS Table ........................................................ 4808 26.3.23 The INFORMATION_SCHEMA PROCESSLIST Table ................................................ 4809 26.3.24 The INFORMATION_SCHEMA PROFILING Table ..................................................... 4810 26.3.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table ....................... 4812 26.3.26 The INFORMATION_SCHEMA RESOURCE_GROUPS Table .................................... 4813 26.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table .............................. 4813 26.3.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table .............................. 4814 26.3.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table .................................. 4815 26.3.30 The INFORMATION_SCHEMA ROUTINES Table ...................................................... 4816 26.3.31 The INFORMATION_SCHEMA SCHEMATA Table ..................................................... 4818 26.3.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table ............................. 4819 26.3.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table ................................... 4820 26.3.34 The INFORMATION_SCHEMA STATISTICS Table .................................................... 4821 26.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table ............................ 4823 26.3.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table ............ 4824 26.3.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table .............................. 4825 26.3.38 The INFORMATION_SCHEMA TABLES Table .......................................................... 4826 26.3.39 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table ................................... 4830 26.3.40 The INFORMATION_SCHEMA TABLESPACES Table ............................................... 4830 26.3.41 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table ........................ 4830 26.3.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table ................................... 4831 26.3.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table ............ 4831 26.3.44 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table ....................................... 4832 4767