Find PK column

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 8 Jun 2005 03:51:22 -0700 (PDT)
Message-ID: <20050608105122.98629.qmail@web52910.mail.yahoo.com>

Hi ,

I am trying to get the table primary key and the column name. How can i query that.

THis is the result i want :

table_name columns_name constraint_name
---------- ------------- ---------------
Material bookid bookid_pk

currently i have tried

select u.table_name, u.column_name, c.constraint_name from user_tab_columns u, user_constraints c where u.table_name=c.user_constraints
and u.table_name='Material'

I can't get the result correctly                                 

---

Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out! http://discover.yahoo.com/weekend.html

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 08 2005 - 06:56:25 CDT