INFORMATION_SCHEMA Table Reference 4775 Table Name Description Introduced Deprecated PARAMETERS Stored routine parameters and stored function return values PARTITIONS Table partition information PLUGINS Plugin information PROCESSLIST Information about currently executing threads PROFILING Statement profiling information REFERENTIAL_CONSTRAINTS Foreign key information RESOURCE_GROUPS Resource group information ROLE_COLUMN_GRANTS Column privileges for roles available to or granted by currently enabled roles 8.0.19 ROLE_ROUTINE_GRANTS Routine privileges for roles available to or granted by currently enabled roles 8.0.19 ROLE_TABLE_GRANTS Table privileges for roles available to or granted by currently enabled roles 8.0.19 ROUTINES Stored routine information SCHEMA_PRIVILEGES Privileges defined on schemas SCHEMATA Schema information SCHEMATA_EXTENSIONS Schema options 8.0.22 ST_GEOMETRY_COLUMNS Columns in each table that store spatial data ST_SPATIAL_REFERENCE_SYSTEMS Available spatial reference systems ST_UNITS_OF_MEASURE Acceptable units for ST_Distance() 8.0.14 STATISTICS Table index statistics TABLE_CONSTRAINTS Which tables have constraints TABLE_CONSTRAINTS_EXTENSIONS Table constraint attributes for primary and secondary storage engines 8.0.21