Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: KEYS (PK , FK)

Re: KEYS (PK , FK)

From: Eric Givler <egivler_at_flash.net>
Date: Sun, 12 Nov 2000 20:59:59 GMT
Message-ID: <jxDP5.112$ND5.16158@news.flash.net>

select * from dba_constraints
where contraint_type in ('U','P','R') /* unique, primary or foreign key constraints)
order by owner_name, table_name, constraint_name

"D. KHADER" <khader_at_rhrk.uni-kl.de> wrote in message news:8uduv4$a9s$1_at_sun.rhrk.uni-kl.de...
> 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
>
>
Received on Sun Nov 12 2000 - 14:59:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US