DB2数据库给表中的列新加自增序列

新增自增
ALTER TABLE DB2INST1.ENTITYPARAMETERVALUE
ALTER COLUMN PKEY SET GENERATED ALWAYS AS IDENTITY
(START WITH 1805293522, INCREMENT BY 1);

 

删除自增

ALTER TABLE DB2INST1.ENTITYPARAMETERVALUE
ALTER COLUMN PKEY DROP IDENTITY;