Thursday, May 7, 2009

How to find constraint definition in oracle

You can find the definition of a constraint by using the following query

select DBMS_METADATA.GET_DDL('CONSTRAINT', 'XXXX') from dual;

Here instead of XXXX you have to use the name of the constraint.

No comments:

Post a Comment