Re: primary key?

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

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost. Received on Sun Jun 15 1997 - 00:00:00 CDT