| 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.
|