Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

primary key fields

Status
Not open for further replies.
castleWolf

castleWolf

Instructor
Jan 23, 2005
26
AZ
How to find primary key tables in database tables?

thanx
 
Sort by date Sort by votes
What do you call "primary key tables"? Ones that have primary key? You may query USER_CONSTRAINTS:

Code: 
select table_name 
from USER_CONSTRAINTS 
where constraint_type='P'

Regards, Dima
 
Upvote 0 Downvote
it partially worked :)
i changed USER_CONSTRAINTS to ALL_CONSTRAINTS
thanx for help
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LarrySteele
  • Locked
  • Question
Searching multiple fields for any/all words from a search string.
Replies
2
Views
104
LarrySteele
LarrySteele
kernal
  • Locked
  • Question
CONCAT DayofWeek Fields if Field Value =Y 3
Replies
4
Views
101
kernal
kernal
IanWaterman
  • Locked
  • Question
Find tables without a Primary Key 1
Replies
2
Views
100
IanWaterman
IanWaterman
JJOHNS
  • Locked
  • Question
Primary Key Workaround
Replies
7
Views
110
Beilstwh
Beilstwh
getjbb
  • Locked
  • Question
Concatenate Date and Time fields
Replies
8
Views
320
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top