.tables — Display the list of table and view names
.tables [table-pattern]
table-pattern
The .tables command displays the list of names for all of the table and view objects that are found in the main and temp databases.
.tables
main
temp