db2 建表

 

------------------DB2-工具生成查看是如此建表的--------------
CREATE TABLE    USERTABLE (

               ID BIGINT  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE )  ,

            CONSTRAINT CC1324543327859 PRIMARY KEY ( ID)

  ) ;

 

------------------自己偏爱这样写----------------------------------

 

 

CREATE TABLE    USERTABLE (

             ID  BIGINT PRIMARY KEY NOT NULL  GENERATED ALWAYS AS IDENTITY(START WITH 1,INCREMENT BY 1,MO CACHE)

  ) ;