IBM Books

Administration Guide


OBJCAT.REFERENCES

Contains a row for each defined referential constraint.

Table 113. OBJCAT.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.
ORIGIN_TABSCHEMA CHAR(8)
Qualified name of the table where the referential constraint was introduced.
ORIGIN_TABNAME VARCHAR(18)
Note:

  1. The OBJCAT.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 ]