The driver supports standard ODBC API functions that enable applications to retrieve metadata without SQL queries.
The following table lists the supported 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 | Returns an empty result because xBase doesn’t support foreign keys. |
| SQLPrimaryKeys | Returns an empty result because xBase doesn’t support primary keys. |
| SQLProcedures | Returns an empty result because xBase doesn’t support stored procedures. |
| SQLProcedureColumns | Returns an empty result because xBase doesn’t support stored procedures. |
| 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. |