Rails cookbook:
*Playing with Tables using rails console
Playing with Tables using rails console
suggest changeView tables
ActiveRecord::Base.connection.tablesDelete any table.
ActiveRecord::Base.connection.drop_table("users")
------------OR----------------------
ActiveRecord::Migration.drop_table(:users)
------------OR---------------------
ActiveRecord::Base.connection.execute("drop table users")Remove index from existing column
ActiveRecord::Migration.remove_index(:users, :name => 'index_users_on_country')where country is a column name in the migration file with already added index in users table as shown below:-
t.string :country,add_index: trueRemove foreign key constraint
ActiveRecord::Base.connection.remove_foreign_key('food_items', 'menus')where menus has_many food_items and their respective migrations too.
Add column
ActiveRecord::Migration.remove_column :table_name, :column_namefor example:-
ActiveRecord::Migration.add_column :profiles, :profile_likes, :integer, :default => 0
Found a mistake? Have a question or improvement idea?
Let me know.