Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where to view SQLite tables Django created?

I am following the tutorials for Django 1.7.7 and I am at the part where I created the tables in the database, but I have no idea where to go to view them.

It says to open my command line client for your database and type in .schema I opened Python and imported sqlite3 and ran .schema, but that didn't work. I also ran sqlite3.exe and ran .schema but not seeing anything.

Does anyone know what I am doing wrong?

I am following this guide. https://docs.djangoproject.com/en/1.7/intro/tutorial01/

like image 955
Brian Pham Avatar asked Mar 28 '15 19:03

Brian Pham


People also ask

How do I view a SQLite table?

If you are running the sqlite3 command-line access program you can type ". tables" to get a list of all tables. Or you can type ". schema" to see the complete database schema including all tables and indices.

Where are SQLite tables stored?

The Android SDK provides dedicated APIs that allow developers to use SQLite databases in their applications. The SQLite files are generally stored on the internal storage under /data/data/<packageName>/databases.

How can I see all SQLite databases?

To show all databases in the current connection, you use the . databases command. The . databases command displays at least one database with the name: main .


1 Answers

Run python manage.py dbshell and this will open your db client with the current database settings.

like image 182
catavaran Avatar answered Sep 21 '22 23:09

catavaran