[Django]-How to view database and schema of django sqlite3 db

I have been stumbling around for an hour aiming to replicate DESCRIBE table inside the Django shell, and think I’ve cracked it.
I hope this is of use to others.

In the Terminal – enter the following commands.

python3 manage.py dbshell
.tables

Find the name of the table you are looking for, then run the following commands:

.header on
.mode column
pragma table_info('table you are looking for');

Do not forget the semicolon in the last instruction.

First, run the command below:

python manage.py dbshell

To access sqlite3 command-line client as shown below:

Then, run the command below:

.table

Or run the command below:

.tables

To show all the tables in SQLite as shown below:

Then, run the command below:

.schema --indent store_product

To show the schema of "store_product" table as shown below:

You can use the following command to get the sql script for the database created.

python manage.py sqlmigrate app_label migration_name

You can view your db.sqlite file online.
sqlite Online

Just upload your file there and you can see your tables which are in your db.sqlite file.

Just wanted to add that someone can find the migrations under my_project_name>my_app_name>migrations and usually you pick the one with the biggest number.

Then the command should be like: python manage.py sqlmigrate my_app_name number