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?
Type of the constraint definition: C - Check constraint on a table. P - Primary key. U - Unique key. R - Referential integrity.
USER_CONSTRAINTS describes all constraint definitions on tables owned by the current user. Its columns are the same as those in "ALL_CONSTRAINTS". Scripting on this page enhances content navigation, but does not change the content in any way.
An Oracle check constraint allows you to enforce domain integrity by limiting the values accepted by one or more columns. To create a check constraint, you define a logical expression that returns true or false. Oracle uses this expression to validate the data that is being inserted or updated.
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
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With