User`s guide

primarykeys
7-185
primarykeys
Get primary key information for database table or schema
Syntax
k = primarykeys(dbmeta, 'cata', 'sch')
k = primarykeys(dbmeta, 'cata', 'sch', 'tab')
Description
k = primarykeys(dbmeta, 'cata', 'sch') returns primary key information for all
tables in the schema sch, of the catalog cata, for the database whose database metadata
object is dbmeta.
k = primarykeys(dbmeta, 'cata', 'sch', 'tab') returns primary 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 primary key information for the DEPT table:
k = primarykeys(dbmeta,'orcl','SCOTT','DEPT')
k =
'orcl' 'SCOTT' 'DEPT' 'DEPTNO' '1' 'PK_DEPT'