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

多于一个时报错:
SQL0372N A column with data type or attribute ROWID, IDENTITY, security label, or row change timestamp can only be specified once for a table.

【俊哥儿张】生成列和标识列实例详解 http://www.itpub.net/thread-1093099-1-1.html

DB2修改表中一列为自动增长主键的方法

DB2的自增列标识列

http://blog.csdn.net/ben0133/archive/2010/09/03/5861924.aspx

DB2 PrimaryKey 主键操作SQL总结 <-> DB2 Derby Paged Select SQL分页查询语句

DB2 Alter 增加自增列 Add AutoIncrement Column

DB2修改表中一列为自动增长主键的方法

DB2的自增列 标识列

DB2的自增列标识列