Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: querying constraints
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
![]() |
![]() |