# Wiping the database?

**URL:** <https://www.ruby-forum.com/t/wiping-the-database/145466>\
**Category:** Rails\
**Created:** [August 10, 2008, 6:27am UTC](https://www.ruby-forum.com/t/wiping-the-database/145466 "2008-08-10T06:27:12Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [August 10, 2008, 6:27am UTC](https://www.ruby-forum.com/t/wiping-the-database/145466/1 "2008-08-10T06:27:12Z")

</div>

Does rails have a built in function that wipes (erases everything) in  
the database? Something like rake db:purge?

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [August 10, 2008, 6:39am UTC](https://www.ruby-forum.com/t/wiping-the-database/145466/2 "2008-08-10T06:39:28Z")

</div>

rake db:reset

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [August 11, 2008, 3:47pm UTC](https://www.ruby-forum.com/t/wiping-the-database/145466/3 "2008-08-11T15:47:27Z")

</div>

Just wondering though, is there also a way to drop all the tables in  
the database?

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [August 10, 2008, 7:13am UTC](https://www.ruby-forum.com/t/wiping-the-database/145466/4 "2008-08-10T07:13:22Z")

</div>

That did the trick, thanks!

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [August 11, 2008, 5:24pm UTC](https://www.ruby-forum.com/t/wiping-the-database/145466/5 "2008-08-11T17:24:17Z")

</div>

On Aug 11, 8:46 am, Mike C [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Just wondering though, is there also a way to drop all the tables in  
> the database?

If you’re using migrations, you could use

rake db:migrate VERSION=0

though I believe that still leaves the schema\_info (or  
schema\_migrations) table there.

Jeff

Come to REST with Rails, Oct 4, 2008 in Austin, TX  
[http://www.purpleworkshops.com/workshops/rest-and-web-services](http://www.purpleworkshops.com/workshops/rest-and-web-services)

[softiesonrails.com](http://softiesonrails.com) - blog  
[purpleworkshops.com](http://purpleworkshops.com) - training  
[pragprog.com/titles/cerailn](http://pragprog.com/titles/cerailn) - Upcoming book, Rails for .NET Developers

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [August 12, 2008, 9:50pm UTC](https://www.ruby-forum.com/t/wiping-the-database/145466/6 "2008-08-12T21:50:56Z")

</div>

Thanks. For anyone else wondering about how to do this, I found that  
rake db:drop also works.