[Django]-How do I drop a table from SQLite3 in DJango?

to clear out an application is as simple as writing:

./manage.py sqlclear app_name | ./manage.py dbshell 

then in order to rebuild your tables just type:

./manage.py syncdb

None of the answers shows how to delete just one table in an app. It’s not too difficult. The dbshell command logs the user into the sqlite3 shell.

python manage.py dbshell

When you are in the shell, type the following command to see the structure of your database. This will show you all the table names in the database (and also the column names within tables).

SELECT * FROM sqlite_master WHERE type='table';

In general, Django names tables according to the following convention: “appname_modelname”. Therefore, SQL query that accomplishes your goal will look similar to the following:

DROP TABLE appname_modelname;

This should be sufficient, even if the table had relationships with other tables. Now you can log out of SQLITE shell by executing:

.exit

If you run syncdb again, Django will rebuild the table according to your model. This way, you can update your database tables without losing all of the app data. If you are running into this problem a lot, consider using South – a django app that will migrate your tables for you.

get the DROP statements with

python manage.py sqlclear app_name

then try

python manage.py dbshell

and execute the DROP statement

check out http://docs.djangoproject.com/en/dev/ref/django-admin/

I had the same problem.

For a quick resolve (if you don’t care about losing your tables/data), correct your models.py file with the desired data types, delete the Migration folder and db.SQLite3 file,

then re-run the following commands:

1. python manage.py migrate
2. python manage.py makemigrations
3. python manage.py migrate
4. python manage.py createsuperuser (to create an admin user/pswd to manage admin page)
5. python manage.py runserver

In Django 2.1.7, I’ve opened the db.sqlite3 file in SQLite browser (there is also a Python package on Pypi) and deleted the table using command

DROP TABLE appname_tablename;

and then

DELETE FROM django_migrations WHERE App='appname';

Then run again

python manage.py makemigrations appname
python manage.py migrate appname

Might be worth expanding on a few answers here:

So, you can get access to the dbshell with the following command:

python manage.py dbshell

It is then preferential to use the following:

DROP TABLE appname_tablename CASCADE;

To drop any related tables, effectively mirroring the “on_delete=CASCADE” direction on a field.

In Django 1.9 I had to do Kat Russo’s steps, but the second migration was a little bit tricky. You have to run

./manage.py migrate --run-syncdb