2 Replies Latest reply on Dec 1, 2006 7:52 PM by 543662

    FIND CONSTRAINT NAME GIVEN COLUMN NAMES AND TABLE NAME

    496104
      Hi,

      Does anybody know how to create a sql query that will return a constraint name from user_constraints and user_cons_columns given a table name, a list of columns and the constraint_type.

      For example, I would like to find out a UNIQUE constraint's name on a table T1. This constraint is on columns ('C1', 'C2', 'C3') in table T1.

      Any help is appreciated!

      Thank you.