Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: primary key?
Additionally, on the oracle magazine site www.oramag.com there are some past Tips of the Week that include sqlplus scripts for getting the primary key columns from the tables below.
In article <33a5c2d6.5932229_at_news.u-net.com>, lgmiller_at_elmrd.u-net.com (Graham
Miller) wrote:
>hello,
> If you look in the view 'Dictionary', you will see a list of all
>the useful Oracle dictionary tables and a description of what they
>hold.
>
>If you investigate the table 'all_constraints' and 'all_cons_columns',
>it should help you to work out what the keys are.
>
>If still having problems then feel free to contact me.
>
>graham (aka grumpy).
>
>swpark_at_namusoft.com (Sangwook Park) wrote...
>
>| I'm using Oracle 7.3.
>| I want to know the primary key of tables.
>| How can I know that?
>| I heard that the primary key was able to be found from tables by using ODBC.
>| But, I'm using sql*plus and OCI.
>| Let me know the primary key of tables .
>| Thanks advance.
>| --
>| Sangwook Park swpark_at_namusoft.com
>| Namusoft http://www.namusoft.com
>
>Graham Miller ...
>Opinions expressed are mine, they are free, and worth exactly what they cost.
Received on Tue Jun 17 1997 - 00:00:00 CDT