How to drop columns using Rails migration

ruby-on-rails ruby database activerecord rails-migrations
Ethan picture Ethan · May 14, 2010 · Viewed 392.2k times · Source

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

Answer

Nick Hammond picture Nick Hammond · Jun 3, 2010 
remove_column :table_name, :column_name

For instance:

remove_column :users, :hobby

would remove the hobby Column from the users table.

Related questions

delete_all vs destroy_all?

I am looking for the best approach to delete records from a table. For instance, I have a user whose user ID is across many tables. I want to delete this user and every record that has his ID in …

Read More
Can you get DB username, pw, database name in Rails?

I'm writing a rake task that does some DB work outside of Rails/ActiveRecord. Is there a way to get the DB connection info (host, username, password, DB name) for the current environment as defined in database.yml? I'd like …

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