DB2 重新设定表自增字段的当前值

转自:http://blog.csdn.net/jionghan3855/article/details/2709073

1.ALTER TABLE UKEY_INFO_TAB ALTER COLUMN UKEYID RESTART WITH 12000

2.ALTER TABLE UKEY_INFO_TAB
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE
  ALTER COLUMN UKEYID
    RESTART WITH 12000

原文地址:https://www.cnblogs.com/wangpei/p/3277718.html