Previous Topic: SYSCONSTROBJ (CNO)Next Topic: SYSVIEWDEP (VWD)


SYSCONSTRSRC (CNS)

SYSCONSTRSRC contains the source for constraints.

Column Name

Data Type

Description

CREATOR

CHAR(18)

Authorization ID of the Constraint

CNAME

CHAR(32)

Constraint Name

TYPE

CHAR

'C' - column or table constraint, including view WITH CHECK OPTION constraints
'U' - UNIQUE Constraint
'P' - Primary Key
'F' - Foreign Key

DELRULE

CHAR

' ' - No delete rule is applicable
'R' - ON DELETE RESTRICT
'C' - ON DELETE CASCADE
'N' - ON DELETE SET NULL
'D' - ON DELETE SET DEFAULT

SEQNO

SMALLINT

Sequence of this row within the series of rows for this constraint (starts at zero)

TOTLEN

SMALLINT

Total length of the source

TEXT

CHAR(254)

A segment of the source