Access metadata

Applications and users can access MySQL metadata through the driver in the following ways:

• ODBC API functions: The driver supports standard ODBC functions that allow metadata retrieval through the API, without the need to write SQL queries. These functions include SQLColumns, SQLForeignKeys, SQLPrimaryKeys, SQLTables, and more.

  For a complete list of supported functions and detailed descriptions, see ODBC functions for metadata retrieval.

• Data dictionary tables: MySQL’s metadata is stored in a comprehensive set of data dictionary tables, which provide details about tables, columns, constraints, and relationships. These tables can be accessed via INFORMATION_SCHEMA views and SHOW statements.

  For more information, see Data dictionary tables.