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

[Anukul Singhal]

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",
assword => "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

 

[Prabhas Gupte]

[Note: parts of this message were removed to make it a legal post.]

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

_connection(
:adapter => "sqlserver",
:host => "113.130.232.221,1342",
:username => "username",
assword => "password",
:database => "DIT_VW_1008"
)

print con.methods