User`s guide

exportedkeys
7-123
exportedkeys
Retrieve information about exported foreign keys
Syntax
e = exportedkeys(dbmeta, 'cata', 'sch')
e = exportedkeys(dbmeta, 'cata', 'sch', 'tab')
Description
e = exportedkeys(dbmeta, 'cata', 'sch') returns foreign exported key
information (that is, information about primary keys that are referenced by other tables)
for the schema sch, of the catalog cata, for the database whose database metadata
object is dbmeta.
e = exportedkeys(dbmeta, 'cata', 'sch', 'tab') returns exported foreign key
information for the table tab, in the schema sch, of the catalog cata, for the database
whose database metadata object is dbmeta.
Examples
Get foreign exported key information for the schema SCOTT for the database metadata
object dbmeta.
e = exportedkeys(dbmeta,'orcl','SCOTT')
e =
Columns 1 through 7
'orcl' 'SCOTT' 'DEPT' 'DEPTNO' 'orcl'...
'SCOTT' 'EMP'
Columns 8 through 13
'DEPTNO' '1' 'null' '1' 'FK_DEPTNO'...
'PK_DEPT'
The results show the foreign exported key information.
Column Description Value
1 Catalog containing primary key that is exported null