Tuesday, 17 May 2016

How to check the constraints in Oracle

Use the below query to check all the constraints in Oracle.

select * from all_cons_columns;

select * from all_constraints where constraint_name='<constraint_name>'

No comments:

Post a Comment