# How can i get all table names of an mysql database

**URL:** <https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466>\
**Category:** Rails\
**Created:** [June 4, 2008, 4:40am UTC](https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466 "2008-06-04T04:40:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tristan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/96bed5/32.png) [@tristan](https://www.ruby-forum.com/u/tristan)\
**Post date:** [June 4, 2008, 4:40am UTC](https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466/1 "2008-06-04T04:40:13Z")

</div>

after i connect to a mysql database,how can i get the table names in  
this db?

---

<div class="post-metadata">

**Author:** ![tristan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/96bed5/32.png) [@tristan](https://www.ruby-forum.com/u/tristan)\
**Post date:** [June 4, 2008, 4:43am UTC](https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466/2 "2008-06-04T04:43:44Z")

</div>

mysql\> show tables;

---

<div class="post-metadata">

**Author:** ![tristan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/96bed5/32.png) [@tristan](https://www.ruby-forum.com/u/tristan)\
**Post date:** [June 4, 2008, 4:44am UTC](https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466/3 "2008-06-04T04:44:54Z")

</div>

but,how can i do this using Rails?

---

<div class="post-metadata">

**Author:** ![tristan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/96bed5/32.png) [@tristan](https://www.ruby-forum.com/u/tristan)\
**Post date:** [June 4, 2008, 6:07am UTC](https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466/4 "2008-06-04T06:07:23Z")

</div>

thanks

---

<div class="post-metadata">

**Author:** ![tristan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/96bed5/32.png) [@tristan](https://www.ruby-forum.com/u/tristan)\
**Post date:** [June 4, 2008, 5:08am UTC](https://www.ruby-forum.com/t/how-can-i-get-all-table-names-of-an-mysql-database/139466/5 "2008-06-04T05:08:53Z")

</div>

> but,how can i do this using Rails?

ActiveRecord::Base.connection.tables

Will return an array of all the table names.