Practical Mobile Forensics - Fourth Edition

Exploring SQLite special commands

Once you connect to a database, you can use a number of built-in SQLite commands that are known as dot commands and that can be used to obtain information from the database files.

You can obtain the list of special commands by issuing the .help command in the SQLite prompt. These are SQLite-specific commands, and they do not require a semicolon at the end. The most commonly used dot commands include the following:

• .tables: This lists all of the tables within a database. The following screenshot displays the list of tables found inside the sms.db database:

• .schema table-name: This displays the SQL CREATE ...