User`s guide

7 Functions — Alphabetical List

7-124

Column Description Value

2 Schema containing primary key that is exported SCOTT

3 Table containing primary key that is exported DEPT

4 Column name of primary key that is exported DEPTNO

5 Catalog that has foreign key null

6 Schema that has foreign key SCOTT

7 Table that has foreign key EMP

8 Foreign key column name, that is the column name that

references the primary key in another table

DEPTNO

9 Sequence number within the foreign key 1

10 Update rule, that is, what happens to the foreign key

when the primary key updates

null

11 Delete rule, that is, what happens to the foreign key

when the primary key is deleted

12 Foreign key name FK_DEPTNO

13 Primary key name that is referenced by foreign key PK_DEPT

In the schema SCOTT, only one primary key is exported to (referenced by) another table.

DEPTNO, the primary key of the table DEPT, is referenced by the field DEPTNO in the table

EMP. The referenced table is DEPT and the referencing table is EMP. In the DEPT table,

DEPTNO is an exported key. Reciprocally, the DEPTNO field in the table EMP is an imported

key.

For a description of codes for update and delete rules, see the getExportedKeys

property on the Oracle Java Web site:

http://docs.oracle.com/javase/7/docs/api/java/sql/

DatabaseMetaData.html.