Oracle USER_INSTINTS表的约束_类型列中的字母代码代表什么?

内容来源于 Stack Overflow,并遵循CC BY-SA 3.0许可协议进行翻译与使用

  • 回答 (2)
  • 关注 (0)
  • 查看 (31)
select distinct constraint_type from user_constraints;

C
-
C
P
R
U

似乎P表示主键,R表示外键,对吗?什么是U和C?

提问于
用户回答回答于
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

扫码关注云+社区