DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.COLOPTIONS catalog view

Each row contains column-specific option values.

Table 1. SYSCAT.COLOPTIONS Catalog View
Column Name Data Type Nullable Description
TABSCHEMA VARCHAR (128)   Schema name of the nickname.
TABNAME VARCHAR (128)   Nickname for the column for which options are set.
COLNAME VARCHAR (128)   Local column name.
OPTION VARCHAR (128)   Name of the column option.
SETTING CLOB (32K)   Value.