What do the letter codes in the Oracle_contraints table mean for the constraint_type table?

select distinct constraint_type from user_constraints; C - C P R U 

It seems that P stands for primary key, and R stands for foreign key, right? What is U and C?

+55
oracle constraints
Oct 08 '08 at 16:26
source share
2 answers
 Code Description Acts On Level --------------------------------------------- C Check on a table Column O Read Only on a view Object P Primary Key Object R Referential (Foreign Key) Column U Unique Key Column V Check Option on a view Object 
+53
Oct 08 '08 at 16:31
source share

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 
+58
Aug 24 2018-10-10T00:
source share



All Articles