Get table name by constraint name

The Solution to Get table name by constraint name is


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.

~ Answered on 2011-03-09 15:20:10


Most Viewed Questions: