> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Browsing a connection

> Filter a table, read its structure and DDL, open routines and triggers, export or share results, and find past queries in TablePro for Windows

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 5](https://mintcdn.com/ngquct/adx2tuXPrXr8k0kG/images/windows-table-filter.png?fit=max\&auto=format\&n=adx2tuXPrXr8k0kG\&q=85\&s=98026a00625facb97f003dd644219bb5)

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 key](https://mintcdn.com/ngquct/adx2tuXPrXr8k0kG/images/windows-table-structure.png?fit=max\&auto=format\&n=adx2tuXPrXr8k0kG\&q=85\&s=49617e13a55aa32defa56685e2b3b783)

Indexes of the Track table

| Section | Shows |
| - | - |
| Columns | Name, type, nullable, default, primary key, auto increment, comment |
| Indexes | Name, columns in order with `DESC` where descending, unique, condition of a partial index |
| Foreign keys | Columns, the table and columns they reference, on delete and on update actions |
| DDL | The `CREATE TABLE` statement, with **Copy** |

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 Reload](https://mintcdn.com/ngquct/adx2tuXPrXr8k0kG/images/windows-definition.png?fit=max\&auto=format\&n=adx2tuXPrXr8k0kG\&q=85\&s=751853dcdf82bd4517bf18ac31311c13)

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:

| Database | Shows the source of |
| - | - |
| PostgreSQL, SQL Server | Functions, procedures, triggers, sequences |
| MySQL, MariaDB | Functions, procedures, triggers, and MariaDB sequences |
| SQLite | Triggers |
| ClickHouse | Functions |

## 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**.

| Setting | Default | Choices |
| - | - | - |
| Results kept per run | No limit | No limit, 10, 20, 50, 100, 200, 500, 1,000 |

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 XML](https://mintcdn.com/ngquct/adx2tuXPrXr8k0kG/images/windows-export-results.png?fit=max\&auto=format\&n=adx2tuXPrXr8k0kG\&q=85\&s=8d198123afd0303940d6a1e5260557ce)

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](https://docs.tablepro.app/windows/account.md); signed out, the share dialog offers **Sign in...**.

| To share | Do this |
| - | - |
| The result a query tab shows | Right-click the results grid and choose **Share result...**, or choose **Share result...** in the **File** menu |
| A table's rows, with its filter and sort | Right-click the table's grid and choose **Share...**, or choose **Share result...** in the **File** menu |
| The selection, or the whole query when nothing is selected | Right-click in the editor and choose **Share query...**, or choose **Share query...** in the **File** menu |

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](https://docs.tablepro.app/features/shared-links.md#the-share-sheet), and the column choices in [Sensitive data](https://docs.tablepro.app/features/shared-links.md#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 duration](https://mintcdn.com/ngquct/adx2tuXPrXr8k0kG/images/windows-query-history.png?fit=max\&auto=format\&n=adx2tuXPrXr8k0kG\&q=85\&s=9e2b367fcb478528b94b087096326b41)

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

| Action | Shortcut |
| - | - |
| Show or hide the filter bar | `Ctrl+Shift+F` |
| Apply the filter | `Enter` in a value box |
| Export results | `Ctrl+Shift+E` |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.