Export (0) Print
Expand All

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

Show:
© 2014 Microsoft