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

# SHOW FILE CACHE

Lists the names of the database's
[file caches](https://docs.kinetica.com/content/config.md#config-main-file-cache).  File caches can be shown by
any user.

```sql title="SHOW FILE CACHE Syntax" theme={null}
SHOW FILE < CACHES | CACHE [<cache name>] >
```

Specify a `<cache name>` to show only that file cache; the only file cache is
`external_files`.  Cache names are case-sensitive and must be given in
lowercase.

To see the settings of the file caches, use [DESCRIBE FILE CACHE](https://docs.kinetica.com/content/sql/system_properties/describe-file-cache.md); to see the
entries held in each file cache and the usage statistics of the caches, query
the [ki\_file\_cache\_entries](https://docs.kinetica.com/content/catalogs/kinetica.md#ki-file-cache-entries) and [ki\_file\_cache\_stats](https://docs.kinetica.com/content/catalogs/kinetica.md#ki-file-cache-stats)
catalog tables.

## Response

The response to `SHOW FILE CACHE` is a single-column result set,
`CACHE_NAME`, with one row per file cache.

## Examples

To list the file caches:

```sql SHOW FILE CACHES Example theme={null}
SHOW FILE CACHES
```


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