db2 增字段

第一创建表的时候就创建自增字段，语法：

CONNECT TO SAMPLES

CREATE TABLE T_TEST (

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

F_NAME VARCHAR (10) )

CONNECT RESET

第二种就是修改已有表的字段为自增字段：

db2 =>alter table ORGAN_NODE alter column ID set GENERATED ALWAYS AS

IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE )

ALTER TABLE 表名 ADD COLUMN 字段 CHAR(1) CHECK (字段 in ('T', 'F'))

COMMENT ON column 模式名.表名.字段 IS 't和f的注释'

---