Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Where to view SQLite tables Django created?

Tags:

python-3.x

django

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
Sign in to Comment

Related questions

Django: Two different child classes point to same parent class
django dumpdata empty array
How to Implement 301 Redirects with Django/Heroku
Admin FileField current url incorrect
Displaying a DecimalField with currency in the django admin
Django user-to-groups in userAdmin, and group-to-users in groupAdmin
function in django settings?
Django "No Module Named URLs" error
Python Django: in view is it better to add properties to an object or make a dictionary of the data?
How to pass a list from a view to template in django
How do you delete an embedded document using Mongoengine?
Django + South - migration can't cast the column type - wants me to use "USING"
How to access data from models in view in Django?
How do you freeze an unfrozen model so you can continue to use South?
django template conditional html
Django Haystack: responsibilities of the template and model indexes
django admin list_filter "or" condition
Django 1.7 multisite User model
Models.DateField Format issues
get Default language of browser in Django

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!