MDAC 2.5 SDK - ODBC Programmer's Reference
Chapter 7: Catalog Functions
ODBC contains the following catalog functions:
| Function | Description |
| SQLTables | Returns a list of catalogs, schemas, tables, or table types in the data source. |
| SQLColumns | Returns a list of columns in one or more tables. |
| SQLStatistics | Returns a list of statistics about a single table. Also returns a list of indexes associated with that table. |
| SQLSpecialColumns | Returns a list of columns that uniquely identifies a row in a single table. Also returns a list of columns in that table that are automatically updated. |
| SQLPrimaryKeys | Returns a list of columns that compose the primary key of a single table. |
| SQLForeignKeys | Returns a list of foreign keys in a single table or a list of foreign keys in other tables that refer to a single table. |
| SQLTablePrivileges | Returns a list of privileges associated with one or more tables. |
| SQLColumnPrivileges | Returns a list of privileges associated with one or more columns in a single table. |
| SQLProcedures | Returns a list of procedures in the data source. |
| SQLProcedureColumns | Returns a list of input and output parameters, the return value, and the columns in the result set of a single procedure. |
| SQLGetTypeInfo | Returns a list of the SQL data types supported by the data source. These data types are generally used in CREATE TABLE and ALTER TABLE statements. |
Because SQLTables, SQLColumns, SQLStatistics, and SQLSpecialColumns conform to the X/Open CLI, and SQLGetTypeInfo conforms to the ISO 92 CLI, they are implemented by most drivers. The remaining catalog functions are in the ODBC conformance level.