Silver Light Silver Light - 3 months ago 6
SQL Question

How to TRUNCATE TABLE using Django's ORM?

To empty a database table, I use this SQL Query:

TRUNCATE TABLE `books`


How to I truncate a table using Django's models and ORM?

I've tried this, but it doesn't work:

Book.objects.truncate()

Answer

The closest you'll get with the ORM is Book.objects.all().delete().

There are differences though: truncate will likely be faster, but the ORM will also chase down foreign key references and delete objects in other tables.