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

by

As far as I know there is no management command to drop all tables. If you don’t mind hacking Python you can write your own custom command to do that. You may find the sqlclear option interesting. Documentation says that ./manage.py sqlclear Prints the DROP TABLE SQL statements for the given app name(s).

Update:
Shamelessly appropriating @Mike DeSimone‘s comment below this answer to give a complete answer.

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

As of django 1.9 it’s now ./manage.py sqlflush

More Related Contents:

  1. How can I temporarily disable a foreign key constraint in MySQL?
  2. Problems with contenttypes when loading a fixture in Django
  3. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  4. Django MySQL full text search
  5. GROUP_CONCAT equivalent in Django
  6. What’s the best way to migrate a Django DB from SQLite to MySQL?
  7. How to use django models with foreign keys in different DBs?
  8. Database returned an invalid value in QuerySet.dates()
  9. Error installing mysqlclient for python on Ubuntu 18.04
  10. django cannot connect mysql in docker-compose
  11. how to get similar search results in MySQL?
  12. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  13. Can I concatenate multiple MySQL rows into one field?
  14. Disable ONLY_FULL_GROUP_BY
  15. How do I see all foreign keys to a table or column?
  16. Get records with highest/smallest per group
  17. Mac OS X – EnvironmentError: mysql_config not found
  18. How do I change the data type for a column in MySQL?
  19. How to connect mysql workbench to running mysql inside docker?
  20. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  21. MySQL Group By and Sum total value of other column
  22. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  23. Export a MySQL Database to SQLite Database
  24. SQL search multiple values in same field
  25. Removing duplicates with unique index
  26. MySQL – Select the last inserted row easiest way
  27. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  28. ALTER table – adding AUTOINCREMENT in MySQL
  29. Does MySQL foreign_key_checks affect the entire database?
  30. How to search and replace all instances of a string within a database?

Leave a Comment