Get table name by constraint name

oracle constraints
sergionni picture sergionni · Mar 9, 2011 · Viewed 129.4k times · Source

Oracle constraint name is known.

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

Answer

Justin Cave picture Justin Cave · Mar 9, 2011 
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.

Related questions

Display names of all constraints for a table in Oracle SQL

I have defined a name for each of the constraint for the multiple tables that I have created in Oracle SQL. The problem is that to drop a constraint for the column of a particular table I need to know …

Read More
Oracle find a constraint

I have a constraint called users.SYS_C00381400. How do I find what that constraint is? Is there a way to query all constraints?

Read More
How to drop all user tables?

How can I drop all user tables in oracle? I have problem with constraints. When I disable all it is still no possible.

Read More