75 
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?

Improve this question

2 Answers 2

Reset to default
78

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
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

75 
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
Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.