SYSIMPORTEDKEYS

SYSIMPORTEDKEYS

Class

SQL Applications

Purpose

Description of the primary key columns that are referenced by the foreign key

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 being imported
PKTABLE_SCHEM	C	30	Primary key table schema being imported
PKTABLE_NAME	C	30	Primary key table name being imported
PKCOLUMN_NAME	C	30	Primary key column name being imported
FKTABLE_CAT	C	30	Foreign key table catalog
FKTABLE_SCHEM	C	30	Foreign key table schema
FKTABLE_NAME	C	30	Foreign key table name
FKCOLUMN_NAME	C	30	Foreign key column name
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 sysimportedkeys;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer