Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check If constraint exists

MarcLafJun 9 2011 — edited Jun 9 2011
Hi,

I want to check if a constraint exists on a table:

FK constraint on TABLE A that refers to TP_ID column in the TP Table.

Which oracle tables contains the constraint information for my query?

I know the all_constraints and all_cons_columns table contains information, but where do I get the column name for the referred table, TABLE TP in my case?

Thanks in advance,

Marc.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2011
Added on Jun 9 2011
3 comments
6,489 views