User`s guide

7 Functions — Alphabetical List
7-32
Column Description Value
1 Catalog that contains primary key, referenced by
foreign imported key
orcl
2 Schema that contains primary key, referenced by
foreign imported key
SCOTT
3 Table that contains primary key, referenced by
foreign imported key
DEPT
4 Column name of primary key, referenced by
foreign imported key
DEPTNO
5 Catalog that has foreign key orcl
6 Schema that has foreign key SCOTT
7 Table that has foreign key EMP
8 Foreign key column name that references the
primary key in another table
DEPTNO
9 Sequence number within 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
1
12 Foreign imported key name FK_DEPTNO
13 Primary key name in referenced table PK_DEPT
There is only one foreign key in the schema SCOTT. The table DEPT contains a primary
key DEPTNO that is referenced by the field DEPTNO in the table EMP. The field DEPTNO in
the EMP table is a foreign key.
Tip For a description of the codes for update and delete rules, see the
getCrossReference property on the Oracle Java Web site:
http://docs.oracle.com/javase/7/docs/api/java/sql/
DatabaseMetaData.html.