SYSCROSSREFERENCE

SYSCROSSREFERENCE

Class

SQL Applications

Purpose

Description of how one table imports the keys of another table

See Also

DATA TYPES, SELECT, SYSTEM TABLES

Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.

Column	Data Type	Width	Description
PKTABLE_CAT	C	30	Primary key table catalog
PKTABLE_SCHEM	C	30	Primary key table schema
PKTABLE_NAME	C	30	Primary key table name
PKCOLUMN_NAME	C	30	Primary key column name
FKTABLE_CAT	C	30	Foreign key table catalog being exported
FKTABLE_SCHEM	C	30	Foreign key table schema being exported
FKTABLE_NAME	C	30	Foreign key table name being exported
FKCOLUMN_NAME	C	30	Foreign key column name being exported
KEY_SEQ	N	2	Sequence number within foreign key
UPDATE_RULE	N	2	What happens to foreign key when primary is updated
DELETE_RULE	N	2	What happens to the foreign key when primary is deleted
FK_NAME	C	30	Foreign key name
PK_NAME	C	30	Primary key name
DEFERRABILITY	N	2	Can the evaluation of foreign key constraints be deferred until commit?

Example

EXEC SQL
SELECT *
FROM syscrossreference;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer