drop table dep cascade; create table dep ( code integer primary key, name text not null ); insert into dep values(1001, '総務部'); insert into dep values(1002, '営業部'); insert into dep values(1003, '開発部');