【SAP HANA 4】序列（Sequence）

1、创建序列

CREATE SEQUENCE Z_SERVICE_LOG_SEQ INCREMENT BY 1 MAXVALUE 999999999 MINVALUE 1 CYCLE;

2、获取序列

SELECT Z_SERVICE_LOG_SEQ.NEXTVAL FROM DUMMY;

3、删除序列

DROP SEQUENCE Z_SERVICE_LOG_SEQ;

4、获取当前序列

SELECT Z_SERVICE_LOG_SEQ.currval  AS MAX_TASK_NO_SEQ FROM DUMMY 

5、序列还原到1 

ALTER SEQUENCE Z_SERVICE_LOG_SEQ INCREMENT BY 1;