Difference between revisions of "SYSIMPORTEDKEYS"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| 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" | + | {| class="wikitable" width=100% |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
| Line 29: | Line 29: | ||
|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? |
|- | |- | ||
|} | |} | ||
Revision as of 07:30, 21 January 2013
Contents
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
SELECT * FROM sysimportedkeys
