Chapter 20. Obtaining Database Metadata

Databases contain data, but information about the way databases are structured is metadata. This chapter discusses the various means by which MySQL provides access to metadata for database, tables, and other objects. It covers the following exam topics:

• Metadata access methods

• Using the INFORMATION_SCHEMA database to access metadata

• Using SHOW and DESCRIBE statements to access metadata

• Using the mysqlshow program to access metadata