Obtaining information about the data source system tables
SQLColumnPrivileges
Returns a list of columns and associated privileges for the specified table. The driver returns the information as a result set on the specified StatementHandle. This function is supported by an appropriate SQL execution.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ODBC
SQLColumns
Returns a list of columns and associated privileges for the specified table. The driver returns the information as a result set on the specified StatementHandle. This function is supported by an appropriate SQL execution.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: X/Open
SQLForeignKeys
Returns two type of lists:
▪ Foreign keys in the specified table (columns in the specified table that refer to primary keys in other tables).
▪ Foreign keys in other tables that refer to the primary key in the specified table.
The driver returns each list as a result set on the specified statement.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ODBC
SQLPrimaryKeys
Returns the list of column names that make up the primary key for a table. The driver returns the information as a result set. This function does not support returning primary keys from multiple tables in a single call.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ODBC
SQLProcedureColumns
Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. The driver returns the information as a result set on the specified statement.
Version introduced: 1.0
Availability when using ODBC: Supported.
Conformance: ODBC
SQLProcedures
Returns the list of procedure names stored in a specific data source. Procedure is a generic term used to describe an executable object, or a named entity that can be invoked using input and output parameters.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ODBC
SQLSpecialColumns
Returns the following information about columns within a specified table:
▪ The optimal set of columns that uniquely identifies a row in the table.
▪ Columns that are automatically updated when any value in the row is updated by a transaction.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: X/Open
SQLStatistics
Returns statistics about a single table and the list of indexes associated with the table. The driver returns the information as a result set.
Version introduced: 1.0
Availability when using ODBC: Supported
SQLTablePrivileges
Returns a list of tables and the privileges associated with each table. The driver returns the information as a result set on the specified statement.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ODBC
SQLTables
Returns the list of table, catalog, or schema names, and table types, stored in a specific data source.