django - generate CREATE TABLE sql for models

Question

Is there any way in django to generate the CREATE TABLE script for my models for a particular DB engine? (MySQL in my case)

Andrey Maslov · Accepted Answer · 2020-06-28 00:13:30Z

5

you can use command in console

python manage.py sqlmigrate <appname> migration_name

where migration name is the name of file with migration that you need. e.g.

python manage.py sqlmigrate manager 0001_initial

answered Jun 28, 2020 at 0:13

Andrey Maslov

1,4661 gold badge9 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Massera Over a year ago

thanks! that's useful. But what if the table has been created and modified in many migrations? I guess I just can temporarily delete all migrations, create a new migration for everything, and then run this and extract the table I want.

folen gateis · Accepted Answer · 2024-05-31 15:49:09Z

1

if you want to smartly compress your migrations and get (maybe) your full sql script in one shot, you can run squashmigrations before sqlmigrate

python manage.py squashmigrations app_label [start_migration_name] migration_name

Squashes the migrations for app_label up to and including migration_name down into fewer migrations, if possible. The resulting squashed migrations can live alongside the unsquashed ones safely.

answered May 31, 2024 at 15:49

folen gateis

2,0003 gold badges16 silver badges30 bronze badges

Collectives™ on Stack Overflow

django - generate CREATE TABLE sql for models

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related