VastbaseG100

基于openGauss内核开发的企业级关系型数据库。

Menu

序列支持NO CACHE、NOCACHE、ORDER、NO ORDER、NOORDER

create sequence SEQ_ID
minvalue 1
maxvalue 40
start with 1
increment by 1
nocache
order;
create sequence SEQ_ID1
minvalue 1
maxvalue 40
start with 1
increment by 1
no cache
noorder;

alter sequence SEQ_ID1 no cache;
alter sequence SEQ_ID nocache;
alter sequence SEQ_ID order;
alter sequence SEQ_ID1 noorder;