How to rename a database column in rails using migration?

Question

I wrongly named one column as hased_password, should have been hashed_password instead. Can i use migration to correct it?

Answer 1

http://api.rubyonrails.org/classes/ActiveRecord/Migration.html

Under "Available Transformations"

rename_column(table_name, column_name, new_column_name): Renames a column but keeps the type and content.

Answer 2

rename_column :table, :old_column, :new_column

Try dizzy, easier for those quick references needs.

Update:

You'll probably want to create a separate migration to do this. (Rename FixColumnName as you will)

script/generate migration FixColumnName
# creates  db/migrate/xxxxxxxxxx_fix_column_name.rb

Then edit the migration to do your will.

# db/migrate/xxxxxxxxxx_fix_column_name.rb
class FixColumnName < ActiveRecord::Migration
  def self.up
    rename_column :table_name, :old_column, :new_column
  end

  def self.down
    # rename back if you need or do something else or do nothing
  end
end

Then just db:migrate as usual or however you go about your business.

Answer 3

imo in this case better use rake db:rollback. Then edit your migration and again type rake db:migrate