User Guide

9. Schema explorer

Chapter 9 of 14 · JiveDB User Guide

The schema explorer, called the Info tab, gives you a read-only, at-a-glance inventory of everything inside one schema (or database) — its tables, views, indexes, and routines — without opening each object one by one. This chapter also covers the quick search box used to jump straight to one object.

Contents

  1. Opening the Info tab
  2. Schema Info
  3. Searching a schema

1. Opening the Info tab

Right-click a schema or database and choose Info (see Chapter 3). This opens a new tab with four sub-tabs: Tables, Views, Indexes, Procedures. Everything shown here is read-only — the Info tab never changes your data or structure.

2. Schema Info

The Info tab has four sub-tabs: Tables, Views, Indexes, and Procedures. Click each tab to view different schema objects:

The Tables sub-tab of the Info tab, listing table name, total size, data size, row count, and comment
The Views sub-tab, showing a view's name and its SELECT definition
The Indexes sub-tab, listing index name, table, and CREATE INDEX statement
The Procedures sub-tab, listing routine name, type, return type, and arguments
Figure 9.1–9.4 — The four sub-tabs of the Info panel: Tables (size & row count), Views (name & definition), Indexes (name, table, & CREATE statement), Procedures (name, type, returns, & arguments).

Tables — Columns: Table, Total size, Data size, Rows (est.), Partitioned, Comment. The exact columns available depend on your database type — for example, MySQL/MariaDB show engine and auto-increment details instead of a partitioned flag.

Views — Columns: View, Definition (the view's underlying SELECT statement).

Indexes — Columns: Index, Table, Definition.

Procedures — Columns: Name, Type (procedure, function, or aggregate), Returns, Arguments. If a function has more than one overload (the same name with different argument types), each overload appears as its own row.

Note: SQLite has no stored procedures, so the Procedures sub-tab is always empty for SQLite connections.

6. Searching a schema

To jump straight to a table, view, or routine by name, right-click the schema and choose Search Database:

A schema search box, listing matching tables, views, and routines with colored type badges
Figure 9.5 — Searching across every object in a schema at once.

Type any part of a name. Results are grouped with a colored badge for their kind: green for TABLE, blue for VIEW, purple for ROUTINE.