Deleting all records in a database table

ruby-on-rails ruby database ruby-on-rails-3
Justin Meltzer picture Justin Meltzer · Mar 16, 2011 · Viewed 101.2k times · Source

How do I delete all records in one of my database tables in a Ruby on Rails app?

Answer

HakonB picture HakonB · Mar 16, 2011

If you are looking for a way to it without SQL you should be able to use delete_all. 

Post.delete_all

or with a criteria

Post.delete_all "person_id = 5 AND (category = 'Something' OR category = 'Else')"

See here for more information.

The records are deleted without loading them first which makes it very fast but will break functionality like counter cache that depends on rails code to be executed upon deletion.

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Difference between rake db:migrate db:reset and db:schema:load

The difference between rake db:migrate and rake db:reset is pretty clear in my head. The thing which I don't understand is how rake db:schema:load different from the former two. Just to be sure that I am …

Read More
Rails :include vs. :joins

This is more of a "why do things work this way" question rather than a "I don't know how to do this" question... So the gospel on pulling associated records that you know you're going to use is to use :…

Read More