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.