Difference between revisions of "SYSEXPORTEDKEYS"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| (4 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" | + | {| 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||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 | + | |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 | + | |valign="top"|FK_NAME||valign="top"|C||valign="top"|30||Foreign key name |
|- | |- | ||
| − | |PK_NAME||C||30||Primary key name | + | |valign="top"|PK_NAME||valign="top"|C||valign="top"|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:42, 31 January 2013
Contents
Purpose
Description of the foreign key columns that reference the primary key columns
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 sysexportedkeys
