Re: KEYS (PK , FK)
From: <sybrandb_at_my-deja.com>
Date: Thu, 09 Nov 2000 12:14:46 GMT
Message-ID: <8ue4fj$jn6$1_at_nnrp1.deja.com>
Date: Thu, 09 Nov 2000 12:14:46 GMT
Message-ID: <8ue4fj$jn6$1_at_nnrp1.deja.com>
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.Received on Thu Nov 09 2000 - 13:14:46 CET