Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_constraints for constriant name, type, table name

SQL> SQL> SQL> select constraint_name, constraint_type,   2         table_name, r_constraint_name   3    from user_constraints   4   where constraint_name = 'DEPARTMENT_FK_MGR_NO'; no rows selected