What do the letter codes in Oracle user_contraints table's constraint_type column stand for?

dacracot picture dacracot · Oct 8, 2008 · Viewed 77.1k times · Source
select distinct constraint_type from user_constraints;

C
-
C
P
R
U

Seems P means primary key and R means foreign key, correct? What are U and C?

Answer

user428974 picture user428974 · Aug 24, 2010

From the 12cR1 documentation:

C - Check constraint on a table  
P - Primary key  
U - Unique key  
R - Referential integrity  
V - With check option, on a view  
O - With read only, on a view  
H - Hash expression  
F - Constraint that involves a REF column  
S - Supplemental logging