• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1page.title=sqlite3
2parent.title=Tools
3parent.link=index.html
4@jd:body
5
6 <p>From a remote shell to your device or from your host machine, you can use the <a href=
7  "http://www.sqlite.org/sqlite.html">sqlite3</a> command-line program to manage SQLite databases
8  created by Android applications. The <code>sqlite3</code> tool includes many useful commands,
9  such as <code>.dump</code> to print out the contents of a table and <code>.schema</code> to print
10  the SQL CREATE statement for an existing table. The tool also gives you the ability to execute
11  SQLite commands on the fly.</p>
12
13  <p>To use <code>sqlite3</code> from a remote shell:</p>
14
15  <ol>
16    <li>Enter a remote shell by entering the following command:
17      <pre>adb [-d|-e|-s {&lt;serialNumber&gt;}] shell</pre>
18    </li>
19
20    <li>From a remote shell, start the <code>sqlite3</code> tool by entering the following command:
21      <pre>sqlite3</pre>
22
23      <p>You can also optionally specify a full path to a database that you want to explore.
24      Emulator/device instances store SQLite3 databases in the directory
25      <code>/data/data/&lt;package_name&gt;/databases/</code>.</p>
26    </li>
27
28    <li>Once you invoke <code>sqlite3</code>, you can issue <code>sqlite3</code> commands in the
29    shell. To exit and return to the adb remote shell, enter <code>exit</code> or press
30    <code>CTRL+D</code>.</li>
31  </ol>
32
33
34      <p>Here's an example:</p>
35      <pre>$ adb -s emulator-5554 shell
36# sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db
37SQLite version 3.3.12
38Enter ".help" for instructions
39<em>.... enter commands, then quit...</em>
40# sqlite&gt; .exit
41</pre>
42
43  <p>To use <code>sqlite3</code> locally, instead of within a shell,
44  pull the database file from the device and start {@code sqlite3}:</p>
45
46  <ol>
47    <li>Copy a database file from your device to your host machine:
48      <pre>
49adb pull &lt;database-file-on-device&gt;
50</pre>
51    </li>
52
53    <li>Start the sqlite3 tool from the <code>/tools</code> directory, specifying the database
54    file:
55      <pre>
56sqlite3 &lt;database-file-on-host&gt;
57</pre>
58    </li>
59  </ol>