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
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
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

user_constraints & user_tab_columns should help.

Previous Topic: First row one column and last row other column
Next Topic: deleting child records directly
Goto Forum:

Current Time: Mon Oct 24 20:54:17 CDT 2016

Total time taken to generate the page: 0.09930 seconds