Chapter 19. INFORMATION_SCHEMA Tables
Table of Contents
19.1. The INFORMATION_SCHEMA SCHEMATA Table
19.2. The INFORMATION_SCHEMA TABLES Table
19.3. The INFORMATION_SCHEMA COLUMNS Table
19.4. The INFORMATION_SCHEMA STATISTICS Table
19.5. The INFORMATION_SCHEMA USER_PRIVILEGES Table
19.6. The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
19.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
19.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
19.9. The INFORMATION_SCHEMA CHARACTER_SETS Table
19.10. The INFORMATION_SCHEMA COLLATIONS Table
19.11. The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
19.12. The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
19.13. The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
19.14. The INFORMATION_SCHEMA ROUTINES Table
19.15. The INFORMATION_SCHEMA VIEWS Table
19.16. The INFORMATION_SCHEMA TRIGGERS Table
19.17. The INFORMATION_SCHEMA PLUGINS Table
19.18. The INFORMATION_SCHEMA ENGINES Table
19.19. The INFORMATION_SCHEMA PARTITIONS Table
19.20. The INFORMATION_SCHEMA EVENTS Table
19.21. The INFORMATION_SCHEMA FILES Table
19.22. The INFORMATION_SCHEMA PROCESSLIST Table
19.23. The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
19.24. The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
19.25. The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
19.26. The INFORMATION_SCHEMA PROFILING Table
19.27. Other INFORMATION_SCHEMA Tables
19.28. Extensions to SHOW Statements
INFORMATION_SCHEMA provides access to database metadata.
Metadata is data about the data, such as the name of a database