More than 5 years have passed since last update.

Railsでテーブルを削除したい時の対処法

Ruby
Rails

Last updated at 2014-09-03Posted at 2014-09-02

rollbackできない時の対処法。

SQLite3::SQLException: table "users" already exists: CREATE TABLE "hoge"

$rails dbconsole

該当するテーブルを削除
sqlite> drop table hoge;

削除されたか確認する

sqlite> .schema

CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL);
CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version");```

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up