Change sequence’s current value (CURRVAL) without dropping it

This is not new but I’ve learned about it last week 🙂 from one of developers when reviewing codes with them for the plan to change the sequence’s current value. Normally I would drop the sequence and create it with START WITH to a new desired number. However, my approach will obviously invalidate all dependencies …

Change sequence’s current value (CURRVAL) without dropping it Read More »