SQL delete all id paths of a model table

Question

Just deleted my all my model tables by (Setting.delete_all). But when I create a new setting it starts from id 12. How do i delete the ids of the "deleted settings"? I want to delete everything so that I start from setting/1 when I create a new setting.

Help, thanks :)

score 1 · Accepted Answer · answered Sep 16 '13 at 12:32

1

You will need to drop your table and then regenerate it using migration:

To drop table:

rake db:migrate:down VERSION="20130910082232"    #replace with version no. of your table migration

Then create it again:

rake db:migrate:up VERSION="20130910082232"      #replace with version no. of your table migration

answered Sep 16 '13 at 12:32

Aman Garg

4,198
2
21
29

Thanks so much! Exactly what I was looking for :) Have a lovely day! – fynn Sep 16 '13 at 12:47

SQL delete all id paths of a model table

1 Answers1