DB2筑表ID自动增长

DB2建表ID自动增长CREATE TABLE T_TEST_DIC(ID integer generated always as identity (start with 1 incr

DB2建表ID自动增长

CREATE TABLE T_TEST_DIC(   ID integer generated always as identity (start with 1 increment by 1)  NOT NULL,   TYPE                VARCHAR(100),   VALUE              VARCHAR(100),   CONSTRAINT P_TEST_DIC_KEY_1 PRIMARY KEY (ID));

?