# SHOW PERSONAL FILES

Returns a list of files in the personal space ([Cloud Portal](https://portal.singlestore.com) > Editor > Personal).

## Syntax

```
SHOW PERSONAL FILES
    [ LIKE '<pattern>' ]
    [ ORDER BY '<key>' [ ASC | DESC ],... ]
    [ LIMIT <limit> ] [ RECURSIVE ] [ EXTENDED ]
```

## Arguments

* `pattern`: Specifies a pattern similar to the SQL `LIKE` clause and returns files with names that match the specified pattern. Uses `%` as the wildcard character.
* `key`: Key used to sort the result set.
* `limit`: An integer value.

## Remarks

* The `LIMIT` clause limits the number of results to the specified number.
* By default, the result is sorted in the ascending order.
* Specify the `RECURSIVE` clause to list the files recursively.
* Specify the `EXTENDED` clause to return more information on the files.

## Example

The following command lists the files in the personal space with additional information:

```sql
SHOW PERSONAL FILES EXTENDED;
```

***

Modified at: May 19, 2026

Source: [/cloud/reference/fusion-sql/show-personal-files/](https://docs.singlestore.com/cloud/reference/fusion-sql/show-personal-files/)

(An index of the documentation is available at /llms.txt)