AUTO INCREMENT

DB2 Alter 增加自增列 Add AutoIncrement Column

Categories: Database; Tagged with: AUTO INCREMENT • DB2 • SQL; @ October 5th, 2010 21:17

ALTER TABLE TABLE2 ALTER COLUMN ID2 DROP DEFAULT SET GENERATED AS IDENTITY ( START WITH 0 INCREMENT BY 1 NO CACHE ) ;