1. check 约束:
(1) 建表时: create table tb1( gender char(2) check(gender =''男 or gender= '女') )
(2)建表后:
添加check约束: alter table tb1 add constraint ch_gender check( gender = '男' or gender= '女' )
//修改check约束:alter table tb1 alter constraint ch_gender check( gender = '男' or gender= '女' ) ??
删除check约束:alter table tb1 drop constraint ch_gender