Show Tables Using .tables SQLite Command

.tables is the special SQLite command that is used to extract the list of tables from the database file. It is specific to the SQLite command line shells and doesn’t work in SQL scripts. Internally .tables executes the query over the SQLite_master table and lists out the tables present in the database file.

The below image shows How to see all the tables in a database using the .tables command:

Steps to Follow:

1. Open the SQLite3 command line interface either on the command prompt or by directly running the .exe file.
2. To use the database in SQLite there is command called .open. So here we have used the student.db database which is store locally in the system. Make sure to have our database in the same folder from which we have started the command line interface of the .
3. Now simply execute .tables special command to get the list of tables in the student database.

SQLite is a lightweight database library written in C which is used for embedding the database with applications. SQLite is a serverless, lightweight, cross-platform, and highly reliable database engine that provides the standard SQL syntax making it easy to use standalone or integrate with any other programming language. SQLite is used to develop embedded applications and is widely used in small-scale and medium-scale databases.

In this article, we will understand how to show tables of databases using various methods and so on. After reading this article you will have decent knowledge about how to SHOW Tables in SQLite.