Ruby on Rails: How do I add a not null constraint to an existing column using a migration?

ruby-on-rails database migration constraints notnull

change_column_null :table_name, :column_name, false

ruby-on-rails database migration constraints notnull

For Rails 4+, nates' answer (using change_column_null) is better.

Pre-Rails 4, try change_column.

ruby-on-rails database migration constraints notnull

1) FIRST: Add column with default value

2) THEN: Remove default value

add_column :orders, :items, :integer, null: false, default: 0change_column :orders, :items, :integer, default: nil

CodeHunter