On 28 Jun 2015, at 1:24pm, bob_sqlite at web.de wrote: > I teach pupils SQL in school. > > I want to create exercises about the SQLite database of Whatsapp. > > Can you tell me the names of tables and the names of columns?
Open the database in the SQLite command-line tool and issue this command .schema It will tell you all about the tables. Download the command-line tool under 'Precompiled Binaries' here: <https://www.sqlite.org/download.html> Simon.