[Django]-What is the django command to delete all tables?

If you have the client libraries installed for your database, you can run this:

python manage.py sqlflush | python manage.py dbshell

This doesn’t drop the tables, but truncates them.

There isn’t a command that does the it all in one go, but this “one liner” will drop all the tables and then re-create them. It would only work if you were running on a system that provides these utilities at the shell.

echo 'from django.conf import settings; print settings.INSTALLED_APPS; quit();' | python manage.py shell --plain 2>&1 | tail -n1 | sed -r "s|^.*\((.*)\).*$|\1|; s|[',]| |g; s|django\.contrib\.||g" | xargs python manage.py sqlclear | python manage.py dbshell && python manage.py syncdb

Neither manage.py sqlclear nor manage.py reset is capable of dropping all tables at once, both require an appname parameter.

You should take a look at Django Extensions, it gives you access to manage.py reset_db as well as many other useful management commands.

I recommend using django-south. It allows you to sync your models to your database not just when you add a field, but also when you delete a field/model. I really find it to be an essential component of building a Django site. Once installed, you could run a command like:

./manage.py migrate app zero

You can learn more here: http://south.aeracode.org/docs/about.html

And a simpler oneliner to drop all the tables for django 1.5+:

python2 manage.py sqlflush | sed 's/TRUNCATE/DROP TABLE/g'| python2 manage.py dbshell

I was able todrop my tables. Run

python manage.py sqlclear appname

Take note of the commands given. Then run

python manage.py dbshell

Add the commands given in the first step. line by line. When you are done, type ‘.exit’ (for SQlite3). Resync your DB and you should be good to go. To be sure, check the tables with:

python manage.py shell
>>> from yourapp import yourclasses
>>> yourviews.objects.all()

it should return a []. I hope this helps.

A implies B, right?

For A, see How to drop all tables from the database with manage.py CLI in Django?

For C,

python manage.py syncdb

Ofcourse for smart data migration I go with what @bento mentioned: django-south