Difference between revisions of "SYSCROSSREFERENCE"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 8: | Line 8: | ||
System Tables are system defined read-only tables. You can query these tables using the SELECT statement. | System Tables are system defined read-only tables. You can query these tables using the SELECT statement. | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
Line 19: | Line 19: | ||
|PKCOLUMN_NAME||C||30||Primary key column name | |PKCOLUMN_NAME||C||30||Primary key column name | ||
|- | |- | ||
− | |FKTABLE_CAT||C||30||Foreign key table catalog being exported | + | |valign="top"|FKTABLE_CAT||valign="top"|C||valign="top"|30||Foreign key table catalog being exported |
|- | |- | ||
− | |FKTABLE_SCHEM||C||30||Foreign key table schema being exported | + | |valign="top"|FKTABLE_SCHEM||valign="top"|C||valign="top"|30||Foreign key table schema being exported |
|- | |- | ||
− | |FKTABLE_NAME||C||30||Foreign key table name being exported | + | |valign="top"|FKTABLE_NAME||valign="top"|C||valign="top"|30||Foreign key table name being exported |
|- | |- | ||
− | |FKCOLUMN_NAME||C||30||Foreign key column name being exported | + | |valign="top"|FKCOLUMN_NAME||valign="top"|C||valign="top"|30||Foreign key column name being exported |
|- | |- | ||
|KEY_SEQ||N||2||Sequence number within foreign key | |KEY_SEQ||N||2||Sequence number within foreign key | ||
|- | |- | ||
− | |UPDATE_RULE||N||2||What happens to foreign key when primary is updated | + | |valign="top"|UPDATE_RULE||valign="top"|N||valign="top"|2||What happens to foreign key when primary is updated |
|- | |- | ||
− | |DELETE_RULE||N||2||What happens to the foreign key when primary is deleted | + | |valign="top"|DELETE_RULE||valign="top"|N||valign="top"|2||What happens to the foreign key when primary is deleted |
|- | |- | ||
|FK_NAME||C||30||Foreign key name | |FK_NAME||C||30||Foreign key name | ||
Line 37: | Line 37: | ||
|PK_NAME||C||30||Primary key name | |PK_NAME||C||30||Primary key name | ||
|- | |- | ||
− | |DEFERRABILITY||N||2||Can the evaluation of foreign key constraints be deferred until commit? | + | |valign="top"|DEFERRABILITY||Valign="top"|N||valign="top"|2||Can the evaluation of foreign key constraints be deferred until commit? |
|- | |- | ||
|} | |} |
Latest revision as of 10:41, 31 January 2013
Contents
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
SELECT * FROM syscrossreference