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

Home -> Community -> Usenet -> c.d.o.misc -> Re: querying constraints

Re: querying constraints

From: Brian E Dick <bdick_at_cox.net>
Date: Tue, 17 Sep 2002 17:54:03 GMT
Message-ID: <%_Jh9.65995$8F4.1629574@news2.east.cox.net>


Primary keys are constraints. You should find what you need with

SELECT *
FROM DICTIONARY
WHERE TABLE_NAME LIKE '%CONS%'; "Torry Slaton" <tslaton_at_tcshealthcare.com> wrote in message news:uoel3fjv4sgmfb_at_corp.supernews.com...
> Anybody know how I can query a table and get the primary key fields?
>
> Thanks!
> Torry
>
>
Received on Tue Sep 17 2002 - 12:54:03 CDT

Original text of this message

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