Re: KEYS (PK , FK)

In article <8uduv4$a9s$1_at_sun.rhrk.uni-kl.de>,   "D. KHADER" <khader_at_rhrk.uni-kl.de> wrote:
> hi ,
>
> which statement shall be used , when i want to show the keys of a
 table or
> all keys in an oracle data base ?
>
> cu ,D. Khader
>
>

select table_name, index_name, column_name from user_ind_columns
order by table_name, index_name, column_position /

select * from dict
to see which datadictionary views there are and
select * from dict_columns
for a description of the individual columns in those views.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.