title: How to view database and schema of django sqlite3 db
body: <p>I'm new to django framework.</p>
  <p>I tried to create a simple blog by following djangogirls tutorials.</p>
  <p>Here by default, we get sqlite3 as default database Engine:</p>
  <pre><code>DATABASES = {
      'default': {
          'ENGINE': 'django.db.backends.sqlite3',
          'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
      }
  }
  </code></pre>
  <p>I tried some <a href="https://docs.djangoproject.com/en/1.10/topics/db/queries/" rel="nofollow noreferrer">ORM queries</a> also, Even <a href="https://docs.djangoproject.com/en/1.10/topics/db/sql/" rel="nofollow noreferrer">performed some row sql queries</a></p>
  <p>At my django project, I have this <strong>db.sqlite3</strong> file:</p>
  <pre><code>blog  db.sqlite3  env  manage.py  mysite
  </code></pre>
  <p><strong>My Question:</strong> How to know the schema that django created in this db.sqlite3(I know mysql where I can see details about each database and tables, so here I just want to know more things in sqlite)</p>
  <p>I have sqlite3 in my system and I tried .database command, but it just shows me:</p>
  <pre><code>seq  name             file                                                      
  ---  ---------------  ----------------------------------------------------------
  0    main 
  
                                                                    
  </code></pre>