PKTABLE_CAT |
Name of the catalog for the table containing the primary key. The
value is NULL if this table does not have catalogs.
|
PKTABLE_SCHEM |
Name of the schema for the table containing the primary key.
|
PKTABLE_NAME |
Name of the table containing the primary key. |
PKCOLUMN_NAME |
Name of the column containing the primary key. |
FKTABLE_CAT |
Name of the catalog for the table containing the foreign key. The
value is NULL if this table does not have catalogs.
|
FKTABLE_SCHEM |
Name of the schema for the table containing the foreign key.
|
FKTABLE_NAME |
Name of the table containing the foreign key. |
FKCOLUMN_NAME |
Name of the column containing the foreign key. |
KEY_SEQ |
1-indexed position of the column in the key. |
UPDATE_RULE |
Integer value representing the action applied to the foreign key
when the SQL operation is UPDATE.
|
DELETE_RULE |
Integer value representing the action applied to the foreign key
when the SQL operation is DELETE.
|
FK_NAME |
The name of the foreign key. |
PK_NAME |
The name of the primary key. |
DEFERRABILITY |
An integer value representing whether the foreign key deferrability is
SQL_INITIALLY_DEFERRED, SQL_INITIALLY_IMMEDIATE, or
SQL_NOT_DEFERRABLE.
|