How to count the number of constraints on a given table?

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select count(constraint_name) from user_constraints where table_name=TABLENAME

itoradeveloper

 Profile Answers by itoradeveloper Questions by itoradeveloper

• Jan 6th, 2010

Select count(constraint_name) from user_constraints where table_name='TABLENAME'

Answer Question  Select Best Answer