Browse tools

SQLite workspace

Transaction: none
No database openLocal working copy · original file stays untouched

Top left

Query

Press Control or Command and Enter to run selected SQL, or the whole editor when nothing is selected. Tab and Shift+Tab change indentation. Press Escape, then Tab to leave the editor.

Top right

Results

1,000 rows per statement

Open a database, then run a query to see rows here.

Bottom left

Database objects

No database open.

Activity

    Bottom centre

    Definition

    Select a database object to inspect its SQL definition.

    Bottom right

    Structure

    Columns, indexes, and foreign keys appear here.