Re: Data Dictionary - Primary Keys

hi Craig,
if the tables are your's use USER_CONS_COLUMNS otherwise use ALL_CONS_COLUMNS select table_name, column_name
from user_cons_columns
order by position;

Craig Fullerton wrote:

> hi
>
> i am trying to get a list of the primary key columns in an Oracle 8.0.5
> database, using the data dictionary. Any Ideas?
>
> i need the data returned as
>
> TableName PKColumnName
>
> thanks
>
> ---
> craig fullerton
> idion - fab technology
> 083 785 3423
Received on Mon Dec 21 1998 - 00:30:29 CST