Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
data types where scale is not applicable.
PSEUDO_COLUMN SMALLINT Indicates whether or not the column is a
pseudo-column. Possible values:
SQL.PC_NOT_PSEUDO, SQL.PC_UNKNOWN,
SQL.PC_PSEUDO.
.statistics(qualifier=None, owner=None, table=None,
unique=SQL.INDEX_ALL, accuracy=SQL.QUICK)
Query the data source for information on statistics and available indexes for a
given table. The
table parameter is mandatory.
Possible input values for
unique:
SQL.INDEX_UNIQUE
Return only unique indexes.
SQL.INDEX_ALL
Return all indexes.
Possible input values for
accuracy:
SQL.ENSURE
The data returned for CARDINALITY and PAGES must be current and
accurate. This mode is not widely supported and its use is discouraged.
SQL.QUICK
The data for CARDINALITY and PAGES is returned if available, but must not
be current.
This method is mainly useful for identifying the indexes of a table in a database
schema.
The catalog method generates a result set having the following schema:
Column Name Column Datatype Comment
TABLE_CAT VARCHAR(128) Always NULL.
TABLE_SCHEMA VARCHAR(128) The name of the schema containing
TABLE_NAME.
TABLE_NAME VARCHAR(128) not
NULL
The name of the table, or view, or alias, or
synonym.
130