AnsweredAssumed Answered

How to reset a sequence

Question asked by timschmick on Mar 13, 2015
Latest reply on Sep 10, 2018 by SrinivasanSathiamurthi

What is the official solution for resetting a sequence in DF?  For example, @nextval(thissequence,1)@ will remember the last generated value between publishes, which can be very handy.  We would also like the ability to reset this number back to the starting value.  We tried deleting the dbo.gtseq_thissequence reference in the (MSSQL) GTRepo as a pre-publish action, but this produced an error until we ran it a second time (which did reset the value). 

Outcomes