User Interface

Each database window has three parts:

1. The sidebar, a list of all the tables, views and attached databases
2. The view switcher, for switching between inspecting tasks
3. The work area, which contains details for the current task

The sidebar

This is a list of the databases, tables and views available to you.

In this image:

• main is the current database file
• table is a table
• view is a view
• sqlite_schema is the schema table for the main database

To add a table, or attach another database, use the button.

To rename, alter or drop an item, use the button.

Note

Indexes and triggers are shown within the schema details for their parent table or view and not in the sidebar.

The view switcher

This control lets you switch between tasks.

• The schema tab shows details about the structure of a table, view or database. For a table, this includes things like column names, any indexes and the SQL to describe it.
• The data tab shows the contents of the items selected in the sidebar.
• The SQL tab is for running custom commands or queries on the database
• The Log tab shows a history of SQL instructions run on the database since it was opened.

The work area

This part of the window will change when you select a different item in the view switcher.

• Table Schemas

  ---

  Learn how to inspect and modify table definitions.

  Read more

• Table Contents

  ---

  View and edit data in your tables

  Read more

• Custom SQL

  ---

  Running custom commands & queries

  Read more

• Log

  ---

  View a list of commands run against this database

  Read more