CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 008 -SQL Table Constraint Report

QREPORT 008 -SQL Table Constraint Report

QREPORT 008, the SQL Table Constraint report, lists all of the referential constraints in which each table participates. This report is sorted first by the schema and table names that were requested on the WITH VALUES clause, then the constraint relationship, and finally the constraint name. Constraints where the table being reported is the referencing table are listed first, followed by constraints where the table being reported is the referencing table.

Two tables are involved in each referential constraint. The dependent table is called the referencing table. Data values for certain columns of the referencing table are restricted to only those values that exist in corresponding columns of the table being referenced. These columns in the referencing table are often referred to as foreign key columns; they correspond to referenced columns in the referenced table.

Constraints where the table being reported is the referencing table are listed first in QREPORT 008. Finally, QREPORT 008 lists the constraints where the table being reported is the table being referenced.