How to remove models from django?

Question

In Django how do you remove models that you have synced into the database?

For example in Django tutorial page had this following code

from django.db import models

class Poll(models.Model):
    question = models.CharField(max_length=200)
    pub_date = models.DateTimeField('date published')

class Choice(models.Model):
    poll = models.ForeignKey(Poll)
    choice = models.CharField(max_length=200)
    votes = models.IntegerField()

Then I used python manage.py sql polls and python manage.py sql choice to create the tables into the database. But what if I did something wrong and don't want that model any more. What's the syntax to remove it?

Answer 1

If you don't want to delete and re-sync your current database, the best way is to drop the table from your model manually:

$ python manage.py dbshell

> (Inside the DB shell)
> DROP TABLE {app-name}_{model-name};

Answer 2

Why not simply try deleting the models from your models.py file? When you run

python manage.py makemigrations

the migrations file should be updated with the deleted models.

Answer 3

Commenting out the class that defines the model did it for me. Once I had done it and ran python manage.py makemigrations, I got this as response: - Delete model MyModel. Checked afterwards with a DB Browser and it was actually removed.

Answer 4

The most easiest solution is to just delete your model from models.py and run

python3 manage.py makemigrations

(Note: Remove the model from everywhere where you have imported it like admin.py, views.py, or any other file where you have imported it)

Answer 5

If you are facing issue to update changes onto DB so you can directly run this command.

python manage.py migrate --run-syncdb

Answer 6

Django’s database handling through syncdb is purely additive: any new models will be added, but deleted models will not be deleted and modified models will not be modified.

If you do not have any data you want to preserve, you are fine just dropping and recreating the database: if you have anything you want to preserve, or even if you intend to have anything you want to preserve, I cannot advise you strongly enough to use a migration tool: South has been the de facto standard for every project I’ve worked on.

Answer 7

Since the Migration command handle Model(database) you can do following steps.

First type

python manage.py makemigrations app_name # it will restructure your model

then type

python manage.py migrate app_name # it will apply to restructure your database.

Example: I had Posts and PostDetail model, later on, I wanted to remove PostDetail model and some fields(columns) from Posts model too.

I simply run migrations and migrate commands,checked in Mysql Database. It worked fine.

Hope it will work for you too.

Answer 8

I found a simpler method, by sheer experimentation. Even after deleting tables, Django was not making the migrations, so I did the following:

Simply delete the files created in your myapp->migrations directory, making sure that you do not delete the init.py and pycache

1. Starting from 001initial.py and downwards delete the files.

2. Run python manage.py makemigrations

3. Run python manage.py migrate

-M