DB2创建/修改SEQUENCE

2019独角兽企业重金招聘Python工程师标准>>>

--删除SEQUENCE DROP SEQUENCE TOSS_TB_LOG_SEQ;

--创建一个SEQUENCE

CREATE OR REPLACE SEQUENCE TOSS_TB_EVAL_RESULT_SEQ AS INTEGER

MINVALUE 1 MAXVALUE 2147483647

 START WITH 1 INCREMENT BY 1 CACHE 100 NO CYCLE ORDER;

--修改SEQUENCE起始标志

ALTER SEQUENCE TOSS_TB_EVAL_SEQ RESTART WITH 301;

转载于:https://my.oschina.net/feixuewuhen/blog/608962