Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Resetting a sequence


Is there any simple way to reset a HDBSEQUENCE?

Suppose I have a sequence whose range is 1-100.

In a procedure  I need to reset the sequence and use it but for other procedures I need to just use NEXTVAL.

I have seen the syntax of create sequence with RESET BY option, but I want to just reset the sequence to its initial value .



Former Member
Not what you were looking for? View more on this topic or Ask a question