# Active Record: Query to find all the tables in a database?

**URL:** <https://www.ruby-forum.com/t/active-record-query-to-find-all-the-tables-in-a-database/137144>\
**Category:** Ruby\
**Created:** [May 9, 2008, 11:32am UTC](https://www.ruby-forum.com/t/active-record-query-to-find-all-the-tables-in-a-database/137144 "2008-05-09T11:32:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 9, 2008, 11:32am UTC](https://www.ruby-forum.com/t/active-record-query-to-find-all-the-tables-in-a-database/137144/1 "2008-05-09T11:32:03Z")

</div>

Hi,

I am using the following code snippet to connect to a DB using Active  
Record:

require ‘rubygems’  
require ‘active\_record’

ActiveRecord::Base.establish\_connection(  
:adapter =\> “sqlserver”,  
:host =\> “113.130.232.221,1342”,  
:username =\> “username”,  
:password =\> “password”,  
:database =\> “DIT\_VW\_1008”  
)

It has about 25 tables. I want to print the names of all the tables in  
the database “DIT\_VW\_1008”. Can anyone provide the code to solve my  
problem?

Thanks,  
Anukul

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 9, 2008, 1:50pm UTC](https://www.ruby-forum.com/t/active-record-query-to-find-all-the-tables-in-a-database/137144/2 "2008-05-09T13:50:34Z")

</div>

just for confirmation, do this:  
con = ActiveRecord::Base.establish

> \_connection(  
> :adapter =\> “sqlserver”,  
> :host =\> “113.130.232.221,1342”,  
> :username =\> “username”,  
> :password =\> “password”,  
> :database =\> “DIT\_VW\_1008”  
> )

print con.methods

On Fri, May 9, 2008 at 3:02 PM, Anukul S.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)