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

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

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.
[email protected]

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs