Thursday, May 7, 2009

How to find constraint in oracle

You can find out the name of the constraints for a particular table
from the view user_constraints .

Use the following query

select CONSTRAINT_NAME from user_constraints where table_name='XXXX';

Use the name of your table instead of XXXX.


No comments:

Post a Comment