# Browsing the database

## Opening the database and browsing table structure

:::{figure} ../img/inventory.sqlite-opened-in-rider.png
:name: inventory.sqlite-opened-in-rider
:figwidth: 35%
:align: right
Inventory databases's table `Items` and its columns.
:::

1. Double click `inventory.sqlite`.

   `Data Sources and Drivers` window will open up. Below you should see {{AllIcons_expui_status_warning}} `Download missing driver files`.
   
1. Click `Download`. 
1. Click `OK`.
    
   {{DatabaseIcons_icons_expui_dbms_20x20}} (Database) tab on the right tool bar will be activated and you will see `inventory` as shown in {numref}`inventory.sqlite-opened-in-rider`.

   You see the that the `columns` in the table `Items` correspond to the properties of the class `Item`.
   
   Other tables starting with `sqlite_` are created automatically by the DBMS. We are going to ignore them.
   
## Browsing table content

1. On the `Database` tool, double click `Items`. Alternatively click `Items` then click {{DatabaseIcons_icons_expui_editData}} `Edit Data`. 

   In the editor pane, a new tab `Items` will open up. It will be empty, because we did not store any data.

:::{warning}
In the following examples we will change the structure of the database. Close the `Item` tab, after you have changed the structure. Otherwise, `Item` data can show wrong data.
:::