Generating an image of a database schema used in a Rails app

ruby-on-rails database ruby-on-rails-4 schema
Readonly picture Readonly · Jan 26, 2009 · Viewed 11.2k times · Source

How can I go about generating an image of a database schema used in a Rails app?

Answer

Tom picture Tom · Jan 26, 2009

Have you tried rake db:schema:dump?

Essentially, make sure that your database.yml file is referencing the database you wish to dump, and then run the command. It'll take all of the tables and indexes in said database and then write it out to schema.rb.

Note that you should rename schema.rb once it contains the dump; otherwise, it could it overwritten.

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Rails DB Migration - How To Drop a Table?

I added a table that I thought I was going to need, but now no longer plan on using it. How should I remove that table? I've already run migrations, so the table is in my database. I figure rails …

Read More
Difference between rake db:migrate db:reset and db:schema:load

The difference between rake db:migrate and rake db:reset is pretty clear in my head. The thing which I don't understand is how rake db:schema:load different from the former two. Just to be sure that I am …

Read More