User_constraints
Login to rate this answer.
raman sharma
Answered On : Mar 2nd, 2012
there are different type of constraints
1) primary key
2)unique key
3)foreign key
4)check constraints
Login to rate this answer.
USER_CONSTRAINTS describes constraint definitions on tables in the current users schema.
Login to rate this answer.
rohit
Answered On : Jul 9th, 2012
there are 5 constraints and they are:-
1.primary key
2.foreign key
3.unique
4.not null
5.check
Login to rate this answer.
Ganeshan
Answered On : Jul 12th, 2012
Select * from user_constraints /// To view the constraints at table level
Login to rate this answer.
user-constraints and all_constraints
Login to rate this answer.
Naresh kumar
Answered On : Oct 3rd, 2012
Constraints divided into 3 types those are:
1. domain integrity constraints:- not null,check
2. entity integrity constraints:- unique,Primary key
3. referential integrity constraints:- foreign key
In these not null used only in column level, (check, unique, primary key) are used in all 3 levels (column,table.alter levels) and foreign key can used in table and alter levels only.
Login to rate this answer.