How can i delete database table in django?

Question

I changed my models and made migrations. Then i changed my models another one time and when try python manage.py migrate i get error:

Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions, shop
Running migrations:
  Applying shop.0004_auto_20180128_1331...Traceback (most recent call last):
  File "/home/morilon/dj/intshop/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 83, in _execute
    return self.cursor.execute(sql)
  File "/home/morilon/dj/intshop/venv/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 301, in execute
    return Database.Cursor.execute(self, query)
sqlite3.OperationalError: table "shop_brand" already exists

So my question is - how can i delete table "shop_brand"??? I already tried flush and sqlflush but that only delete data from table but not actually table "shop_brand".

I use django 2.0.1 and python 3.6

Check out [this](https://stackoverflow.com/questions/37083445/reset-sqlite-database-in-django) — Laurynas Tamulevičius, Jan 28 '18 at 16:57
Just delete all files is an option but i want know how to delete only one tablet in database. — Loctarogar, Jan 28 '18 at 17:38

Kevin L. · Accepted Answer · 2018-01-28T17:17:02.673

21

Use the dbshell command

python manage.py dbshell

then while in the shell, depending on what database you are using, you type the command to show tables to identify the table you want to drop.

For instance, for sqlite, you would use

.tables

still in the shell, you can use SQL command to drop the table

DROP TABLE shop_brand;

edited Jan 28 '18 at 17:17

answered Jan 28 '18 at 16:58

Kevin L.

1,371
11
24

I tried but CommandError: You appear not to have the 'sqlite3' program installed or on your path. – Loctarogar Jan 28 '18 at 17:31
see https://stackoverflow.com/questions/37287972/commanderror-you-appear-not-to-have-the-sqlite3-program-installed-or-on-your – Kevin L. Jan 28 '18 at 17:43
or install sqlite3 `sudo apt-get install sqlite3` – Kevin L. Jan 28 '18 at 18:16
Ok i will try. I just thought i can deal with it only with Django. – Loctarogar Jan 28 '18 at 19:02
Why do I still those dropped tables in the admin site :(? – Gakuo Aug 26 '20 at 11:46
2

I CAN NOT restore the table after doing this by makemigrations or migrate – Fathy Oct 17 '22 at 10:17

How can i delete database table in django?

1 Answers1

Linked