Practical Mobile Forensics - Third Edition

SQLite special commands

Once you connect to a database, there are a number of built-in SQLite commands, which are known as dot commands and 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 of the command. The most commonly used dot commands include the following:

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

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