Access metadata

Applications and users can access SAP ASE 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.

• System tables: SAP ASE metadata is stored in a comprehensive set of system tables, which provide details about tables, columns, constraints, relationships, and more. These tables can be queried directly with SQL to explore the database structure and object dependencies.

  For more information, see System tables.