I forgot to mention that if you have any relationship based on the auto_increment column then probably you need to be deleting the relationship first.