create table约束

create table student(

  sage smallint CHECK (sage between 17 and 22),

  ssex char(2) check(ssex in('男','女'))

);

posted @ 2014-05-18 10:22  我就是熊吉  阅读(197)  评论(0编辑  收藏  举报