Oracle 用户_约束表的约束_类型列中的字母代码表示什么？

select distinct constraint_type from user_constraints;


C
-
C
P
R
U

似乎 P 代表主键，R 代表外键，对吗? U 和 C 是什么？

oracle
constraints
oracleinternals

80835 次浏览

小开

最佳答案

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

小开

来自 12cR1文档:

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