How can I rename a database column in a Ruby on Ra

Question

I wrongly named a column hased_password instead of hashed_password.

How do I update the database schema, using migration to rename this column?

Answer 1

Run the below command to create a migration file:

rails g migration ChangeHasedPasswordToHashedPassword

Then in the file generated in the db/migrate folder, write rename_column as below:

class ChangeOldCoulmnToNewColumn < ActiveRecord::Migration
  def change
     rename_column :table_name, :hased_password, :hashed_password
  end
end

Answer 2

From API:

rename_column(table_name, column_name, new_column_name)

It renames a column but keeps the type and content remains same.

Answer 3

If the present data is not important for you, you can just take down your original migration using:

rake db:migrate:down VERSION='YOUR MIGRATION FILE VERSION HERE'

Without the quotes, then make changes in the original migration and run the up migration again by:

rake db:migrate

Answer 4

Simply create a new migration, and in a block, use rename_column as below.

rename_column :your_table_name, :hased_password, :hashed_password

Answer 5

Rails 5 migration changes

eg:

rails g model Student student_name:string age:integer

if you want to change student_name column as name

Note:- if you not run rails db:migrate

You can do following steps

rails d model Student student_name:string age:integer

This will remove generated migration file, Now you can correct your column name

rails g model Student name:string age:integer

If you migrated(rails db:migrate), following options to change column name

rails g migration RemoveStudentNameFromStudent student_name:string

rails g migration AddNameToStudent name:string

Answer 6

Open your Ruby on Rails console and enter:

ActiveRecord::Migration.rename_column :tablename, :old_column, :new_column