Difference between revisions of "SYSIMPORTEDKEYS"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 11: Line 11:
  
 
==See Also==
 
==See Also==
[[DATA TYPES]], [[SQL SELECT|SELECT]], [[SYSTEM TABLES]]
+
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]]
  
  

Revision as of 15:59, 13 March 2009

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