# How to Delete Table from Database?

**URL:** <https://www.ruby-forum.com/t/how-to-delete-table-from-database/169288>\
**Category:** Rails\
**Created:** [June 1, 2009, 11:41pm UTC](https://www.ruby-forum.com/t/how-to-delete-table-from-database/169288 "2009-06-01T23:41:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![devrubygem](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ac8455/32.png) [@devrubygem](https://www.ruby-forum.com/u/devrubygem)\
**Post date:** [June 1, 2009, 11:41pm UTC](https://www.ruby-forum.com/t/how-to-delete-table-from-database/169288/1 "2009-06-01T23:41:37Z")

</div>

I want to delete my project, how do I delete my table inside my sqlite  
database?

Thanks

---

<div class="post-metadata">

**Author:** ![devrubygem](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ac8455/32.png) [@devrubygem](https://www.ruby-forum.com/u/devrubygem)\
**Post date:** [June 1, 2009, 11:43pm UTC](https://www.ruby-forum.com/t/how-to-delete-table-from-database/169288/2 "2009-06-01T23:43:06Z")

</div>

ActiveRecord::Base.connection.drop\_table :your\_table\_name

- 

Maurício Linhares  
[http://alinhavado.wordpress.com/](http://alinhavado.wordpress.com/) (pt-br) | [http://blog.codevader.com/](http://blog.codevader.com/)  
(en)

On Mon, Jun 1, 2009 at 6:41 PM, Zayd C.

---

<div class="post-metadata">

**Author:** ![devrubygem](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ac8455/32.png) [@devrubygem](https://www.ruby-forum.com/u/devrubygem)\
**Post date:** [June 2, 2009, 2:14am UTC](https://www.ruby-forum.com/t/how-to-delete-table-from-database/169288/3 "2009-06-02T02:14:39Z")

</div>

Or, if you created it with a migration, you can just undo it the same  
way (the code is already written for you):

rake db:migrate:down VERSION=x

You can grab the version number from the front of your file name in db  
\migrations

On Jun 1, 5:41 pm, Zayd C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![devrubygem](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ac8455/32.png) [@devrubygem](https://www.ruby-forum.com/u/devrubygem)\
**Post date:** [June 7, 2009, 7:14am UTC](https://www.ruby-forum.com/t/how-to-delete-table-from-database/169288/4 "2009-06-07T07:14:13Z")

</div>

Brian wrote:

> Or, if you created it with a migration, you can just undo it the same  
> way (the code is already written for you):
> 
> rake db:migrate:down VERSION=x
> 
> You can grab the version number from the front of your file name in db  
> \migrations
> 
> On Jun 1, 5:41�pm, Zayd C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

Thanks guys for your help, got things squared away.

Kindest Regards