Auto Incredment clear down

If you every have to clear the Auto Incredment options in the Case management in SuiteCRM/SugarCRM. This will reset the Database auto increment.

 

ALTER TABLE cases AUTO_INCREMENT = 1