Query user_constraints for constriant name, type, table name : USER_CONSTRAINTS « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. USER_CONSTRAINTS

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








Related examples in the same category

1.Get a list of constraints defined on the employee table from User_Constraints
2.Join user_constraints and user_cons_columns table
3.Output user constraints in details