Get table name by constraint name [duplicate]

Question

Oracle constraint name is known.

How do I find the name of the table for which this constraint is applied?

Answer 1

SELECT owner, table_name   FROM dba_constraints  WHERE constraint_name = <<your constraint name>> 

will give you the name of the table. If you don't have access to the DBA_CONSTRAINTS view, ALL_CONSTRAINTS or USER_CONSTRAINTS should work as well.

Answer 2

ALL_CONSTRAINTS describes constraint definitions on tables accessible to the current user.

DBA_CONSTRAINTS describes all constraint definitions in the database.

USER_CONSTRAINTS describes constraint definitions on tables in the current user's schema

Select CONSTRAINT_NAME,CONSTRAINT_TYPE ,TABLE_NAME ,STATUS from  USER_CONSTRAINTS;