changing case number

[extensive]

is there a way to change the start value of the case number? i dont want to assign case values to customers and start at 1 if you know what i mean.

thanks!

[crmsiva]

Hi

Execute the below one in your database.

ALTER TABLE cases AUTO_INCREMENT = 1000;

Now case no will start with 1000.