Home » SQL & PL/SQL » SQL & PL/SQL » Advanced queries in sql
icon4.gif  Advanced queries in sql [message #212239] Thu, 04 January 2007 05:35 Go to next message
hirak1984
Messages: 1
Registered: January 2007
Junior Member
I want to write a query that will tell me the primary key of a table .please help me......
and I also want to get the attribute names of a table,in case user dont know them.
he/she only knows the name of the table
Re: Advanced queries in sql [message #212244 is a reply to message #212239] Thu, 04 January 2007 05:47 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


user_constraints & user_tab_columns should help.



regards,
Previous Topic: group by
Next Topic: Identify who is locks my entity
Goto Forum:
  


Current Time: Sat Aug 19 15:38:51 CDT 2017

Total time taken to generate the page: 0.05493 seconds