To get the User_Constraints on a table , use the below query:Select CONSTRAINT_NAME from USER_CONSTRAINTS where table_name = <tablename>;To know the columns on which these constraints are , use this:select COLUMN_NAME,CONSTRAINT_NAME… more »