how can i get all table names of an mysql database

[Tristan]

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

[Michael_Steinfeld]

show tables;

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

>

[Tristan]

but,how can i do this using Rails?

[Philip_Hallstrom]

but,how can i do this using Rails?

ActiveRecord::Base.connection.tables

Will return an array of all the table names.

[Tristan]

thanks