select distinct constraint_type from dba_constraints;
结果:
CONSTRAINT_TYPE
?
C --check
O
P --primary key
R --forgien key
U --unique
V
其他三个是什么?
constraint的类型:
1、primary key unique and not null,可以是多个column的联合。composite pk只能被定义为table constraint
2、foreign key parent table 中的primary key中的values必须包含child table中所有的values. share column的parent-child 关系
3、unique
4、check present in a static list of values permitted for the column.
5、not null 只能被定义在column constraint
(2,3,4允许null)
Type Code Type Description Acts On Level
C Check on a table Column
O Read Only on a view Object
P Primary Key Object
R Referential AKA Foreign Key Column
U Unique Key Column
V Check Option on a view Object
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/yanleigis/archive/2008/09/23/2965740.aspx