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));
?
发布时间： 2012-11-19 10:18:51 作者： rapoo
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));
?