sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

 

Ans:

yes,

USER_CONSTRAINTS,

system table contains information on constraints on all the tables created

malapati

 Profile Answers by malapati 

• Oct 8th, 2008

 

desc  user_constraints;

to see constraints on a particular table like emp
 

 select  constraint_name,constraint_type,table_name  from  user_constraints;

psingla

 Profile Answers by psingla Questions by psingla

• Mar 5th, 2010

 

For SQL Server users:

SELECT object_name(id) objname,object_name(constid) constraintname,* from sysconstraints where object_name(id)= '<table_name>'