Rails migration for change column

by

Use #change_column.

change_column(:table_name, :column_name, :date)

# a few more examples:
change_column(:suppliers, :name, :string, limit: 80)
change_column(:accounts, :description, :text)

NOTE: the same result can be achieved even outside of db migrations, this might be handy for testing/debugging but this method needs to be used very cautiously:

ActiveRecord::Base.connection.change_column(:table_name, :column_name, :date)

More Related Contents:

  1. Using Rails, how can I set my primary key to not be an integer-typed column?
  2. How can I rename a database column in a Ruby on Rails migration?
  3. Rails DB Migration – How To Drop a Table?
  4. rake db:schema:load vs. migrations
  5. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  6. How do I handle too long index names in a Ruby on Rails ActiveRecord migration?
  7. Rails migration for has_and_belongs_to_many join table
  8. Using Rails Migration on different database than standard “production” or “development”
  9. Add a default value to a column through a migration
  10. How can I rollback a specific migration?
  11. Run a single migration file
  12. Rails 3 migrations: Adding reference column?
  13. Adding foreign key to a rails model
  14. How do I add some inserts in rails migration?
  15. Rails ExecJS::ProgramError in Pages#home?
  16. Rails: How to reference images in CSS within Rails 4
  17. accepts_nested_attributes_for with find_or_create?
  18. Is there a clean way to avoid calling a method on nil in a nested params hash? [duplicate]
  19. Ruby 2.4 and Rails 4 stack level too deep (SystemStackError)
  20. Using Process.spawn as a replacement for Process.fork
  21. Rails 3, has_one / has_many with lambda condition
  22. Validation for URL/Domain using Regex? (Rails)
  23. Form Submit button only works after reload
  24. Why use “self” to access ActiveRecord/Rails model properties?
  25. How to specify a prefix when uploading to S3 using activestorage’s direct upload?
  26. Use bundle exec rake or just rake?
  27. Controlling the order of rails validations
  28. Always getting 401 Unauthorized with new install of Rails + Devise
  29. Rails – passing parameters in link_to
  30. JWT token decoding even when the last character of the signature is changed

Leave a Comment