The driver supports standard ODBC API functions that enable applications to retrieve metadata without writing SQL queries.
The following table describes the ODBC functions for metadata retrieval.
| Function | Description |
|---|---|
| SQLColumns | Retrieves the column details for a specified table. |
| SQLColumnPrivileges | Retrieves the column-level privileges. |
| SQLGetTypeInfo | Returns the supported data types. |
| SQLForeignKeys | Retrieves the foreign key information for tables. |
| SQLPrimaryKeys | Returns the primary key information for tables. |
| SQLProcedures | Retrieves the information about stored procedures, including their names, schemas, parameters, and types. |
| SQLProcedureColumns | Returns the details of stored procedure parameters. |
| SQLSpecialColumns | Retrieves the special column information, such as auto-incremented or row-version columns. |
| SQLStatistics | Provides the index and statistical information for a table. |
| SQLTables | Returns a list of tables and views. |
| SQLTablePrivileges | Retrieves the table-level privileges. |