Rails Migration to make a column null => true

Question

I had originally created a table with column as

t.string   "email",  :default => "", :null => false

The requirement has changed and now I need to allow email to be null. How can I write a migration to make :null => true

possible duplicate of [How to change a nullable column to not nullable in a Rails migration?](http://stackoverflow.com/questions/5966840/how-to-change-a-nullable-column-to-not-nullable-in-a-rails-migration) — laffuste, Mar 10 '14 at 14:53

score 142 · Answer 1 · edited Apr 25 '22 at 16:51

142

change_column_null :users, :email, true

The reverse has a nice option to update existing records (but not set the default) when null is not allowed.

edited Apr 25 '22 at 16:51

Undo

answered Aug 20 '14 at 07:21

user1309272

13

I'd recommend using `change_column_default` along with this if you want `null` to be the default column value. Otherwise it will be `false` or `0`. – Joshua Pinter Nov 08 '15 at 17:38

score 115 · Accepted Answer · edited May 03 '21 at 15:55

115

Try:

change_column :table_name, :email, :string, null: true

edited May 03 '21 at 15:55

shilovk

answered Jun 05 '12 at 17:02

Pratik Khadloya

2

Please consider using `change_column_null` as this `change_column` might not work in certain version – Morty Choi Aug 08 '17 at 07:13

2 Answers2