本文介绍了通过dropandre-createit方式以及使用altersequence命令来调整数据库中序列值的具体操作步骤。前者涉及删除并重新创建序列，后者则直接修改序列增量。这两种方法适用于需要快速调整序列当前值的场景。
2 Solutions:
1. drop and re-create it
drop sequence seqname;
create sequence seqname start with NEWVALUE ...
(Notice: don't forget about sequence's privilege)
2. alter sequence
alter sequence seqname increment by AVALUE -- (e.g., expected - currentVal);
- When AVALUE is a positive number, seqname's value will be increased.
- When AVALUE is a negative number, seqname's value will be reduced.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
