The driver supports standard ODBC API functions that enable applications to retrieve metadata without writing SQL queries.
The following table describes the supported ODBC functions for metadata retrieval.
| Function | Description |
|---|---|
| SQLColumns | Retrieves the column details for a specified table. |
| SQLColumnPrivileges | Returns an empty result. The driver supports this function only because it’s required by the ODBC standard. |
| SQLGetTypeInfo | Returns the supported data types. |
| SQLForeignKeys | Retrieves the foreign key information for tables. |
| SQLPrimaryKeys | Returns the primary key information for tables. |
| SQLProcedures | Returns an empty result. The driver supports this function only because it’s required by the ODBC standard. |
| SQLProcedureColumns | Returns an empty result. The driver supports this function only because it’s required by the ODBC standard. |
| 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 | Returns an empty result. The driver supports this function only because it’s required by the ODBC standard. |