SQLite Manager android exam

Firefox addon sqlite manager
SQLite Manager is a simple SQLite database management tool. The tool will allow you to create, edit and delete SQLite databases.

*Manage Multiple SQLite Databases
*Unlimited SQL Query Windows
*Create, Delete, Rename Tables
*Create columns
*Check DB Integrity
*Ad Hoc SQL Queries

1. Add SQLite Manager to firefox

First we need a database browser in this example we will use FireFox SQLite Manager
You can download it from
https://addons.mozilla.org/en-US/firefox/addon/5817

2. Allow the install

Click the add to firefox button and click install now

3. Restart Firefox to enable the plugin

4. Open the SQLite manager

Tools - SQLite Manager

 5.Select the file type of all files

You need to do this to see the database

6. Select the database

There are two places it could be
32bit os - C:\Program Files\Spiceworks\db\spiceworks_prod.db
64bit os - C:\Program Files (x86)\Spiceworks\db\spiceworks_prod.db

7. Your in

The first tab shows the tables
 

8. 2nd

Allows you to browse / search the database tables

9. 3rd

Allows you to execute sql