Python Programming Blueprints

Diving into the SQLite

You should get into the SQLite3 command prompt:

SQLite version 3.16.2 2017-01-06 16:32:41Enter ".help" for usage hints.sqlite>

If you want to get a list of all the database's tables, you can use the command .tables:

sqlite> .tablesauth_group auth_user_user_permissionsauth_group_permissions django_admin_logauth_permission django_content_typeauth_user django_migrationsauth_user_groups django_session

Here you can see that we have all the tables that we created through the migrate command.

To look at every table structure, you can use the command .schema, and we can use the option --indent, so the output will be displayed in a more readable manner:

sqlite> .schema --indent auth_groupCREATE TABLE IF NOT EXISTS "auth_group"( ...