Difference between revisions of "SYSCROSSREFERENCE"

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:58, 13 March 2009

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