# Local tables

This view displays and allows all user-created local tables to be managed.

Local tables are usually created for caching the data in a local database engine and can be queried later by using a more advanced syntax (GROUP BY, HAVING, MAX, MIN, COUNT, etc). This reduces repeated calls to Veeva Vault for working with data which is not expected to change frequently and can be cached locally, for example for development and testing purposes.

{% hint style="danger" %}
The local table serves as a direct conduit for transferring any alterations to Veeva Vault. This includes updates, edits, and deletions made to the current object or document within Vault. The status bar displays the currently active object.
{% endhint %}

{% hint style="info" %}
The database file where data for the local tables is stored is encrypted and can be read only by dqMan.
{% endhint %}

For more information about creating and querying local tables see [**querying local tables**](/veeva-vault-edition-24.3/session-window-vql-mdl/dqman-proprietary-statements.md#querying-local-tables-by-using-the-full-sqlite-syntax)**.**

<table><thead><tr><th width="364">Menu Option</th><th>What It Does</th><th data-hidden></th></tr></thead><tbody><tr><td><strong>Refresh</strong></td><td>Refreshes the data in the selected table with the current data in Veeva Vault</td><td></td></tr><tr><td><strong>Drop</strong></td><td>Drops the selected local table</td><td></td></tr><tr><td><strong>Load</strong></td><td>Loads the data from the local table into the grid. The query for the local table (including all fields) is added to the query editor</td><td></td></tr><tr><td><strong>Auto-refresh</strong></td><td>Automatically refreshes the local table periodically, starting on the selected date and at the specified interval</td><td></td></tr></tbody></table>

{% hint style="info" %}
Although there is no hard storage limit for the local table, dqMan's recommended threshold for optimal performance is 1 million rows.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.dqman.com/veeva-vault-edition-24.3/vault-navigator/local-tables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.