Try user_cons_columns instead of user_tab_columns.
mvg/regards
Jo
Kean Jacinta
<jacintakean@yahoo To:
oracle-l@xxxxxxxxxxxxx
.com> cc:
Sent by: Subject: Find PK column
oracle-l-bounce@fr
eelists.org
06/08/2005 12:51
Please respond to
jacintakean
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
