Django db Table delete

Question

With what command can i delete tables from a django db of a specific app/ only one table? I did find all sorts of things, but not how to get rid of a table.

Also while I am at this.

I create the models and hit syncdb and then I have the tables. If I want to update/add to those tables, do I run into problems?

Thanks!

Answer 1

If you are deleting a table, this is done in the model file of the specific app that you are trying to delete, there is no command for this, you just go into the file and delete it and then re-run syncdb, for your other question, the answer is the same.. every app folder should have a file called "models.py" and here is where the models which are, in this case, equivalent to tables are specified, along with their fields, you simply edit this to make any changes.

Answer 2

Your best bet would be to get django-south installed in your machine.

if you are using pip, do pip install django-south

This allows you too migrate data forward and backwards.

This is very handy especially if you need to update tables, and new tables etc.

check it out.

adding south to apps are as easy as python manage.py schemamigration appname --initial

Make your changes in a model and run the following python manage.py schemamigration appname --auto

Once your data migration file has been created it'll tell you data is now ready to migrate.

Simply use python manage.py migrate appname

http://south.aeracode.org/docs/about.html

Hope this helps