id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30606	Use .tables for SQLite in tutorial 02	Dinesh Shenoy	nobody	"Hello, I suggest a one-word change to the Tutorial 02 -- Database setup section https://docs.djangoproject.com/en/2.2/intro/tutorial02/#database-setup

Which corresponds to this line in the Sphinx docs:  https://github.com/django/django/blob/master/docs/intro/tutorial02.txt#L98

I recommend that line be amended to

{{{
``.tables`` (SQLite), or ``SELECT TABLE_NAME FROM USER_TABLES;`` (Oracle) to
}}}

The one word to be changed is ""schema"", to be replaced with ""tables"". I suggest this because the goal at that point in the tutorial is to be able to see the tables which were just created by the ""python manage.py migrate"" command.  Running "".tables"" at the sqlite command line shows the tables created:

{{{
$ sqlite3 db.sqlite3
SQLite version 3.26.0 2018-12-01 12:34:55
Enter "".help"" for usage hints.
sqlite> .tables
auth_group                  auth_user_user_permissions
auth_group_permissions      django_admin_log
auth_permission             django_content_type
auth_user                   django_migrations
auth_user_groups            django_session
sqlite>
}}}

Versus if the "".schema"" command is given, that actually outputs all the CREATE TABLE, CREATE INDEX, etc. statements.

Since the sentence in the tutorial says ""If you’re interested, run the command-line client for your database . . . to display the tables Django created"", I think it will be clearer to say use the "".tables"" commands for the default SQLite DB, rather than the "".schema"" command.

Thank you.
"	Cleanup/optimization	closed	Documentation	2.2	Normal	duplicate			Unreviewed	0	0	0	0	1	0