Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
the SQL operation is UPDATE: SQL.RESTRICT,
SQL.NO_ACTION, SQL.CASCADE,
SQL.SET_NULL.
DELETE_RULE SMALLINT Action to be applied to the foreign key when
the SQL operation is DELETE: SQL.CASCADE,
SQL.NO_ACTION, SQL.RESTRICT,
SQL.SET_DEFAULT, SQL.SET_NULL
FK_NAME VARCHAR(128) Foreign key identifier. NULL if not applicable to
the data source.
PK_NAME VARCHAR(128) Primary key identifier. NULL if not applicable to
the data source.
DEFERRABILITY SMALLINT Possible values: SQL.INITIALLY_DEFERRED,
SQL.INITIALLY_IMMEDIATE,
SQL.NOT_DEFERRABLE.
.gettypeinfo(sqltype)
Query the data source for information on a supported data type sqltype.
sqltype must be one of the SQL type codes as returned in
cursor.description[1]. See section 8. Data Types supported by mxODBC
for a list of SQL type codes and details about their use.
This method is useful to determine characteristics of the given SQL data type
and how it is defined in the SQL dialect supported by the data source.
The catalog method generates a result set having the following schema:
Column Name Column Datatype Comment
TYPE_NAME VARCHAR(128) not
NULL
Character representation of the SQL data
type name, e.g. "VARCHAR", "DATE",
"INTEGER".
DATA_TYPE SMALLINT not NULL SQL data type of column identified by
COLUMN_NAME.
COLUMN_SIZE INTEGER If the DATA_TYPE column value denotes a
character or binary string, then this column
contains the maximum length in characters
for the column.
For date, time, timestamp data types, this is
the total number of characters required to
display the value when converted to
120