Skip to content
The latest version of DbVisualizer was released 2024-12-04DOWNLOAD HERE ->

Metadata Cache

The metadata cache is used internally in DbVisualizer to speed up various features such as auto-completion, table data editing, and for functions that gather information about columns, keys, tables, etc. The cache keeps only metadata such as schema, table, and column names. It does not store table data or other sensitive information.

Configuring Metadata Cache

The metadata cache can be set to any of these modes:

  • Persistent (default)
    the metadata is stored in a local cache and is reused for new sessions
  • Transient
    metadata is cleared for each new session
  • Disabled
    the cache is not used at all

When the cache is Persistent, you can specify the number of days to keep stale (not used) contents.

You find the setting for the metadata cache in Tools → Tool Properties and in the Database Connection / Metadata category.

Metadata configuration

Clear Metadata Cache

When metadata has been changed outside DbVisualizer or via scripts, you may need to clear the cache and reload the metadata. This can be done for all connections or for a singe connection.

Clear All Cached Data

To clear metadata for all connections, use File → Clear Metadata Cache

Metadata configuration

You should normally select to Clear the cache. The choice Reset will remove and recreate the metadata cache and should only be used when there are issues with the cache.

Clear Cached Data for Selected Connection(s)

You can clear the cache for one or several selected connections in the Databases tab. Select the connection(s), right-click and then select Clear Metadata Cache for Database(s)

Clear Cached Data from Auto complete Popup

In the auto-complete window in an SQL Commander there is a button to clear the metadata cache for the actual database. This might be handy in case there is a discrepancy what is displayed in the auto-completion window compared with the actual data source.

Metadata configuration