itoradeveloper

 Profile Answers by itoradeveloper 

• Jan 6th, 2010

 

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

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

select count(constraint_name) from user_constraints where table_name=TABLENAME