Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
CARDINALITY INTEGER If the TYPE column contains the value
SQL.TABLE_STAT, this column contains the
number of rows in the table.
If the TYPE column value is not
SQL.TABLE_STAT, this column contains the
number of unique values in the index.
A NULL value is returned if the information
cannot be determined.
PAGES INTEGER If the TYPE column contains the value
SQL.TABLE_STAT, this column contains the
number of pages used to store the table.
If the TYPE column value is not
SQL.TABLE_STAT, this column contains the
number of pages used to store the indexes.
A NULL value is returned if the information
cannot be determined.
FILTER_CONDITION VARCHAR(128) If the index is a filtered index, this is the filter
condition. NULL is returned if TYPE is
SQL.TABLE_STAT or the database does not
support filtered indexes.
.tables(qualifier=None, owner=None, table=None, type=None)
Query the data source for information on tables stored in the database.
type may be set to a comma-separated string of database table types using all
uppercase characters. The exact list of available types is data source
dependent. Common types include:
TABLE, VIEW, SYSTEM TABLE, GLOBAL
TEMPORARY, LOCAL TEMPORARY, ALIAS, SYNONYM
.
This method is useful for checking whether a table exists and is accessible by
the current user or not. It also aids in database schema introspection.
The catalog method generates a result set having the following schema:
Column Name Column
Datatype
Comment
TABLE_CAT VARCHAR(128) The name of the catalog containing TABLE_SCHEM. This
column contains a NULL value.
TABLE_SCHEMA VARCHAR(128) The name of the schema containing TABLE_NAME.
TABLE_NAME VARCHAR(128) The name of the table, or view, or alias, or synonym.
132