Access metadata

Applications and users can access Oracle 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 views: Oracle’s metadata is stored in a comprehensive set of data dictionary views, which provide details about tables, columns, constraints, and relationships. These views can be queried directly with SQL to explore the database structure and object dependencies.

  For more information, see Data dictionary views.