Catalog Functions in ODBC

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 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.

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 and ALTER TABLE statements.