SYSCAT.REFERENCES catalog view

Each row represents a referential integrity (foreign key) constraint.

Table 1. SYSCAT.REFERENCES Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR (128)   Name of the constraint.
TABSCHEMA VARCHAR (128)   Schema name of the dependent table.
TABNAME VARCHAR (128)   Unqualified name of the dependent table.
OWNER VARCHAR (128)   Authorization ID of the owner of the constraint.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
REFKEYNAME VARCHAR (128)   Name of the parent key.
REFTABSCHEMA VARCHAR (128)   Schema name of the parent table.
REFTABNAME VARCHAR (128)   Unqualified name of the parent table.
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   Time at which the constraint was defined.
FK_COLNAMES VARCHAR (640)   This column is no longer used and will be removed in a future release. Use SYSCAT.KEYCOLUSE for this information.
PK_COLNAMES VARCHAR (640)   This column is no longer used and will be removed in a future release. Use SYSCAT.KEYCOLUSE for this information.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the constraint.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.