How to list of all the tables defined for the database when using active record?

by

Call ActiveRecord::ConnectionAdapters::SchemaStatements#tables. This method is undocumented in the MySQL adapter, but is documented in the PostgreSQL adapter. SQLite/SQLite3 also has the method implemented, but undocumented.

>> ActiveRecord::Base.connection.tables
=> ["accounts", "assets", ...]

See activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:21, as well as the implementations here:

More Related Contents:

  1. With Rails 4, Model.scoped is deprecated but Model.all can’t replace it
  2. ActiveRecord::Base Without Table
  3. Is there a way to get a collection of all the Models in your Rails app?
  4. Case-insensitive search in Rails model
  5. Rails 3 ActiveRecord: Order by count on association
  6. Rails model without database
  7. ActiveRecord OR query Hash notation
  8. ActiveRecord, has_many :through, and Polymorphic Associations
  9. Using Rails serialize to save hash to database
  10. Rails 3: Get Random Record
  11. Rails: select unique values from a column
  12. Setting session timeout in Rails 3
  13. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  14. Rails find_or_create_by more than one attribute?
  15. Rails ActiveRecord: Find All Users Except Current User
  16. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  17. belongs_to through associations
  18. Check if record exists from controller in Rails
  19. Rails 4 nested attributes and has_many :through associaton in a form
  20. PostgreSQL where all in array
  21. delete_all vs destroy_all?
  22. Find all records which have a count of an association greater than zero
  23. ActiveRecord serialize using JSON instead of YAML
  24. How to implement Active Record inheritance in Ruby on Rails?
  25. Store the day of the week and time?
  26. has_and_belongs_to_many, avoiding dupes in the join table
  27. Rails gem rails3-jquery-autocomplete: How do I query multiple fields
  28. Rails best way to get previous and next active record object
  29. Escaping SQL queries in Codeigniter
  30. Rails Object Relationships and JSON Rendering

Leave a Comment