Skip to main content
Every object in the tree opens in a tab. Tables and views open as rows, and functions, procedures, triggers and sequences open as their source, read only.

Filter rows

Click Filter in a table tab, or press Ctrl+Shift+F, to show the filter bar above the rows.
1

Pick a column and an operator

The operators match the column’s type: text offers contains and starts with, numbers and dates offer greater than and between, and every column offers is NULL.
2

Type the value

between takes two values. in list takes values separated by commas: 3, 7, 12.
3

Apply

Click Apply or press Enter in a value box. The tab reads the first page again and counts the rows the filter picks.
Track table filtered to 12 rows, with the filter bar showing GenreId, equals and 5Track table filtered to 12 rows, with the filter bar showing GenreId, equals and 5

GenreId equals 5 picks 12 of the Track table's rows

Add a rule with +. With two or more rules, choose Match all or Match any. Raw SQL takes one condition as you would write it after WHERE, such as length(name) > 6. Clear reads the whole table again.
  • A rule missing its value is pointed out before anything runs.
  • A filter the database refuses keeps the filter you had, and the results say why. Refresh reads the rows again.
  • Changing the filter while edits are pending asks before it discards them.
  • The filter stays with the tab when TablePro restarts.

Read a table’s structure

Switch a table tab from Data to Structure.
Structure of the Track table on Indexes, listing three foreign key indexes and the primary keyStructure of the Track table on Indexes, listing three foreign key indexes and the primary key

Indexes of the Track table

The DDL section is empty for a view, whose columns come from its query. Right-click a table in the tree and choose Show structure to open it on Structure directly.

Open functions, procedures, triggers and sequences

Click one in the tree to open its source in a read-only tab. Reload reads it again from the database, and Copy copies it.
Trigger track_renamed shown read only with Open in editor, Copy and ReloadTrigger track_renamed shown read only with Open in editor, Copy and Reload

A trigger's source opens read only

Open in editor puts the text in a new query tab, where you change it and run it. On MySQL, that tab runs in the database the object belongs to. When running the text would not recreate the object as it is, the button is replaced by a note saying so. Which objects show their source depends on the database:

Keep fewer results from a script

A script whose statements return rows lists each result in the picker above the grid. To keep only the newest, set Settings > Queries > Results kept per run. Earlier results are dropped as the script runs, and the status line says how many: Rows: 1 · 12 ms · 990 earlier results were dropped. A statement that returns no rows never counts toward the limit. A change applies from the next run.

Export results

Choose File > Export results or press Ctrl+Shift+E.
Export results dialog with CSV selected among JSON, Excel, Markdown, HTML and XMLExport results dialog with CSV selected among JSON, Excel, Markdown, HTML and XML

Export results from a query tab

1

Pick a format

CSV, JSON, Excel, Markdown, HTML or XML. From a table tab, SQL INSERT writes one statement per row for that table.
2

Pick the rows, in a table tab

Current page writes the rows on screen. Entire table reads every row the filter and sort pick, however many pages they span.
3

Choose where to save

The file appears only once every row is written. A failed or cancelled export leaves no file behind.
From a query tab, export writes the result shown. Export waits until the run has finished. CSV is the default; pick Excel for a spreadsheet, which holds up to 1,048,575 rows.

Share a result or query

Sharing needs a signed-in TablePro account; signed out, the share dialog offers Sign in…. A result can be shared once its run has finished. A table shares from its first row, whichever page is on screen, and Share… is dimmed while edits are pending. When TablePro cannot write the table’s query for its database, the link holds the rows without SQL and opens nothing in TablePro. In the dialog, Share as picks Personal or a team where you hold a seat, and Share creates the link and copies it, with Open in browser beside it. For a result, Columns sets each column to Keep, Mask with a mask, or Remove, and columns that look sensitive start masked. Manage shared links… in the File menu opens your links in the browser. The dialog’s fields, the Free and Pro limits, and what a link sends are in Shared Links, and the column choices in Sensitive data. Opening a tablepro://share link puts its SQL in a new query tab without running it. With no connection open, a dialog shows the SQL with Copy SQL instead.

Find a past query

Choose View > Show query history to open the history beside the tabs. Every query you run in a query tab is kept with its time, duration and outcome, newest first. Type in the search box to find one by any words it contains.
Query history pane listing a SELECT COUNT query with its time and durationQuery history pane listing a SELECT COUNT query with its time and duration

The query history beside the tabs

  • Double-click a query, or select it and press Enter, to open it in a new query tab.
  • Right-click a query to copy or delete it.
  • Clear history removes the history of every connection, after asking.
A statement that can hold a password, such as one that creates a user, is never kept. Sorting a result and committing or rolling back a transaction are not kept either.

Keyboard shortcuts