Oracle的表操作——检查约束

1、检查（check）约束：对输入列或者整个表中的值设置检查条件，以限制输入值，保证数据库数据的完整性

2、创建表时设置检查约束的方法：

（1）、列级约束：

             create table student(

                                                    sid number(8,0),

                                                    name varchar2(20),

                                                    sex char(2) check(sex = '男' or sex = '女'),

                                                     birthday date,

                                                     address varchar2(50)

                                                   );

（2）、表级约束：

               create table student(

                                                    sid number(8,0),

                                                    name varchar2(20),

                                                    sex char(2) ,

                                                     birthday date,

                                                     address varchar2(50),

                                                      constraint ck_sex check(sex = '男' or sex = '女')

                                                   );

3、修改表时添加检查约束的方法：

alter table student add constraint ck_sex check(sex = '男' or sex = '女')

4、删除检查约束的方法：

（1）、暂时删除：alter table student disable constraint ck_sex;

（2）、永久删除：alter table student drop constraint ck_sex;