Rails: How to list database tables/objects using the Rails console? Rails: How to list database tables/objects using the Rails console? ruby-on-rails ruby-on-rails

Rails: How to list database tables/objects using the Rails console?


You are probably seeking:

ActiveRecord::Base.connection.tables

and

ActiveRecord::Base.connection.columns('projects').map(&:name)

You should probably wrap them in shorter syntax inside your .irbrc.


I hope my late answer can be of some help.
This will go to rails database console.

rails db

pretty print your query output

.headers on.mode columns(turn headers on and show database data in column mode )

Show the tables

.table

'.help' to see help.
Or use SQL statements like 'Select * from cars'


To get a list of all model classes, you can use ActiveRecord::Base.subclasses e.g.

ActiveRecord::Base.subclasses.map { |cl| cl.name }ActiveRecord::Base.subclasses.find { |cl| cl.name == "Foo" }