X$Relate

---

The X$Relate system table is associated with the file RELATE.DDF. X$Relate contains information about the referential integrity (RI) constraints defined on the database. X$Relate is automatically created when the first foreign key is created, since this results in a relationship being defined.

The structure of X$Relate is as follows:

 
Table C-21 X$Relate System Table Structure

Column Name	Type	Size	Case Insensitive	Description
Xr$PId	USMALLINT	2	N/A	Primary table ID.
Xr$PIndex	USMALLINT	2	N/A	Index number of primary key in primary table.
Xr$FId	USMALLINT	2	N/A	Dependent table ID.
Xr$FIndex	USMALLINT	2	N/A	Index number of foreign key in dependent table.
Xr$Name	CHAR	20	Yes	Foreign key name.
Xr$UpdateRule	UTINYINT	1	N/A	1 for restrict.
Xr$DeleteRule	UTINYINT	1	N/A	1 for restrict, 2 for cascade.
Xr$Reserved	CHAR	30	No	Reserved.

Five indexes are defined for the X$Relate table, as follows:

 
Table C-22 X$Relate System Table Index Definitions

Index Number	Segment Number	Column Name	Duplicates	Case Insensitive	Segmented
0	0	Xr$PId	Yes	N/A	No
1	0	Xr$FId	Yes	N/A	No
2	0	Xr$Name	No	Yes	No
3	0	Xr$Pld	No	N/A	Yes
3	1	Xr$Name	No	Yes	No
4	0	Xr$Fld	No	N/A	Yes
4	1	Xr$Name	No	Yes	No

Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.