日期:2014-05-16  浏览次数:20438 次

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)
);

?