Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
|---|---|---|---|
foreign_table_id |
SMALLINT |
NOT NULL |
Primary key, foreign key references SYS.SYSCOLUMN. table_id |
foreign_key_id |
SMALLINT |
NOT NULL |
Primary key, foreign key references SYS.SYSFOREIGNKEY. foregin_key_id |
foreign_column_id |
SMALLINT |
NOT NULL |
Primary key, Foreign key references SYS.SYSCOLUMN column_id |
primary_column_id |
SMALLINT |
NOT NULL |
Each row of SYSFKCOL describes the association between a foreign column in the foreign table of a relationship and the primary column in the primary table.
foreign_table_id The table number of the foreign table.
foreign_key_id The key number of the FOREIGN KEY for the foreign table. Together, foreign_table_id and foreign_key_id uniquely identify one row in SYSFOREIGNKEY. The table number for the primary table can be obtained from that row (using the SYSFOREIGNKEY table).
foreign_column_id This column number, and the foreign_table_id identify the foreign column description in SYSCOLUMN.
primary_column_id This column number and the primary_table_id obtained from SYSFOREIGNKEY identify the primary column description in SYSCOLUMN.