Reset Auto Increment of SQL database command in Cakephp

Hello Everyone,

I have a problem with the Auto Increment functionality of my
SQL Server (MySQL). Every time I delete a record of a specific table,
the reference for my auto increment still stays at the id of the
deleted record.
Shouldn't it suppose to move right after the largest id of the table?

Is there any command in cakephp that would reset
the Auto Increment of the table right after you delete a record?
After which it would then point it's auto increment reference at
the end of the table's largest id.

Thanks,
Mario

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---