Download mxODBC - Python ODBC Database Interface

mxODBC - Python ODBC Database Interface
Column Name
Column Datatype
Comment
include any null-terminator. For exact numeric
data types, the length accounts for the decimal
and the sign.
Note: This column is of little value to Python
applications.
DECIMAL_DIGITS
SMALLINT
PSEUDO_COLUMN SMALLINT
The scale of the column. NULL is returned for
data types where scale is not applicable.
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:
98
Column Name
Column Datatype
Comment
TABLE_CAT
VARCHAR(128)
Always NULL.