How do I drop a table from SQLite3 in DJango??

Question

I made a model, and ran python manage.py syncdb. I think that created a table in the db. Then I realized that I had made a column incorrectly, so I changed it, and ran the same command, thinking that it would drop the old table, and add a new one.

Then I went to python manage.py shell, and tried to run .objects.all(), and it failed, saying that column doesn't exist.

I want to clear out the old table, and then run syncdb again, but I can't figure out how to do that.

Answer 1

get the DROP statements with

python manage.py sqlclear  

then try

python manage.py dbshell
and execute the DROP statement

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

Answer 2

another simple way to do this would be

python manage.py reset app_name

which drops and re-creates the tables used by the models of this app.