IBM Books

Administration Guide


SYSCAT.REFERENCES

Contains a row for each defined referential constraint.

Table 84. SYSCAT.REFERENCES Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR(18)
Name of constraint.
TABSCHEMA CHAR(8)
Qualified name of the constraint.
TABNAME VARCHAR(18)
DEFINER CHAR(8)
User who created the constraint.
REFKEYNAME VARCHAR(18)
Name of parent key.
REFTABSCHEMA CHAR(8)
Name of the parent table.
REFTABNAME VARCHAR(18)
COLCOUNT SMALLINT
Number of columns in the foreign key.
DELETERULE CHAR(1)
Delete rule:
  A=NO ACTION
  C=CASCADE
  N=SET NULL
  R=RESTRICT
UPDATERULE CHAR(1)
Update rule:
  A=NO ACTION
  R=RESTRICT
CREATE_TIME TIMESTAMP
The timestamp when the referential constraint was defined.
FK_COLNAMES VARCHAR(320)
List of foreign key column names.
PK_COLNAMES VARCHAR(320)
List of parent key column names.
Note:

  1. The SYSCAT.REFERENCES view is based on the SYSIBM.SYSRELS table from Version 1.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]