SyntaxFix

[oracle] Get table name by constraint name 

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.

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to constraints

• How to trap on UIViewAlertForUnsatisfiableConstraints? • trying to animate a constraint in swift • Remove all constraints affecting a UIView • "Insert if not exists" statement in SQLite • Unique Key constraints for multiple columns in Entity Framework • SQL Server 2008- Get table constraints • How to remove constraints from my MySQL table? • Creating layout constraints programmatically • Display names of all constraints for a table in Oracle SQL • Add primary key to existing table