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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

System Table

Status
Not open for further replies.
drkestrel

drkestrel

MIS
Sep 25, 2000
439
GB
Anyone know from which table could I look at what Foreign Key exists in a schema?

I tried ALL_INDEXES, but no luck!
 
Sort by date Sort by votes
Try ALL_CONS_COLUMN.

Hope that helps... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
 
Upvote 0 Downvote
Or ALL_CONSTRAINTS Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
676
carp
carp
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
582
carp
carp
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
151
carp
carp
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
190
fredericofonseca
fredericofonseca
harfri
  • Locked
  • Question
Insert data from Table A into Table B how can I do that?
Replies
3
Views
191
carp
carp

Part and Inventory Search

Sponsor

Back
Top