Catalog Functions in ODBC
ODBC contains the following catalog functions:
|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 Open Group 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.
This section contains the following topics.