DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.COLGROUPCOLS catalog view

Each row represents a column that makes up a column group.

Table 1. SYSCAT.COLGROUPCOLS Catalog View
Column Name Data Type Nullable Description
COLGROUPID INTEGER   Identifier for the column group.
COLNAME VARCHAR (128)   Name of the column in the column group.
TABSCHEMA VARCHAR (128)   Schema name of the table for the column in the column group.
TABNAME VARCHAR (128)   Unqualified name of the table for the column in the column group.
ORDINAL SMALLINT   Ordinal number of the column in the column group.