Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
IS_NULLABLE VARCHAR(254) Contains the string "NO" if the column is known
to be not nullable, "" if this cannot be
determined, or "YES" if it is known to be nullable.
.specialcolumns(qualifier=None, owner=None, table=None,
coltype=SQL.BEST_ROWID, scope=SQL.SCOPE_SESSION,
nullable=SQL.NO_NULLS)
Query the data source for information on "special" columns of a given table.
The
table parameter is mandatory.
Special columns in this sense are columns which can be used to uniquely
identify a row in the table (e.g. primary keys) or which are automatically
updated by the database (e.g. auto-increment columns).
Possible input values for
coltype:
SQL_BEST_ROWID
Return the optimal column or set of columns for uniquely identifying a row
in the table (the rowid).
SQL_ROWVER
Return columns that are automatically updated by the database when the
row is updated.
Possible input values for
scope:
SQL.SCOPE_CURROW
The rowid column(s) are only guaranteed to be valid as long as the rows
remain unchanged.
SQL.SCOPE_TRANSACTION
The rowid is guaranteed to be valid for the duration of the current
transaction.
SQL.SCOPE_SESSION
The rowid is guaranteed to be valid for the duration of the connection.
Possible input values for
nullable:
SQL.NO_NULLS
Exclude special columns that nullable. Using this option can result in an
empty result set, if the table, driver or database don't support such
requirements.
SQL.NULLABLE
Return special columns, even if they can have NULL values.
128