Change Position of Existing column in Rails

Question

I have one Column in my Table, i want to change its position from last to second, can anyone please help me to do that. thanks in Advance.i have idea about after: column_name, but its apply while Adding new column. How to change position of Exciting column?

User
  first_name
  last_name
  middle_name
  mobile_NO

i want like this

User
  first_name
  mobile_no
  last_name
  middle_name

What rails version you are using? – Imran Ahmad May 23 '19 at 09:02 — Imran Ahmad, May 23 '19 at 09:02

score 2 · Accepted Answer · answered May 23 '19 at 08:58

2

You can call change_column migration, like shown below:

def up
  change_column :your_table, :some_column, :integer, after: :other_column
end

For more information have look into this: Rails 4 migration: how to reorder columns

answered May 23 '19 at 08:58

Rasna Shakya

527
2
13

Thank you, i was doing same, just missing `DataType` `integer`, rest of all i completed, anyway, thanks again. – Ketan Mangukiya May 23 '19 at 09:10

Change Position of Existing column in Rails

1 Answers1