Catalog Functions in ODBC
Collapse the table of content
Expand the table of content

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:
© 2016 Microsoft