Hi Richard,
you may use following query to get the name of the primary key on a table:
SELECT constraint_name
FROM dba_constraints
WHERE table_name = 'MY_TABLE'
AND owner = 'MY_TABLE_OWNER'
AND constraint_type = 'P';
The table name and the table owner name must be written in uppercase.
In Oracle there is no stored procedure to get this kind of info. You will have to query the views of the Oracle data dictionary.
Hope this helps,
Vlad
>Hi,
>
>Using SQL passthrough I need to return the primary key of an Oracle table. Against Microsoft SQL Server I can call the stored procedure or directly query the syscolumns and sysobjects tables.
>
>Are there equivalents in Oracle ?
>
>Thanks,
>
>Richard
Vlad-Georg