drop table emp; create table emp ( code integer not null unique, name text not null, gender integer check(gender in(1, 2)), -- 1:male, 2:female age integer, tel text not null );