DB2建表

create table P_User(
             ID integer not null primary key,
             Name varchar(60),
             SEX varchar(3),
             TELEPHONE varchar(20),
             ADDRESS varchar(50),
             cellphone varchar(20)
      )


create table P_User(
             ID  decimal(17)   GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1 )  primary key not null, //主键自动增长
             Name varchar(60),
             SEX varchar(3),
             TELEPHONE varchar(20),
             ADDRESS varchar(50),
             cellphone varchar(20)
      ) 

 

posted on 2015-04-16 16:37  博客园Jason  阅读(231)  评论(0编辑  收藏  举报

导航