> ## 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 DIRECTORY

Outputs the DDL statement required to reconstruct one or all
[KiFS directories](https://docs.kinetica.com/content/tools/kifs_api.md#kifs-directory).

```sql title="SHOW DIRECTORY Syntax" theme={null}
SHOW DIRECTOR[Y|IES] [ '<directory name>' | * ]
```

> [!NOTE]
>
> Only one *directory* can be named; a comma-separated list will return
> an error.  To output a *directory's* detail instead of its DDL, see
> [LIST DIRECTORY](https://docs.kinetica.com/content/sql/kifs/list-directory.md#sql-kifs-list-dir).

## Parameters

> [accordion] \<directory name>
>
> Name of the existing *directory* whose DDL will be output.
> Use `*`, or omit the name entirely, to output the DDL of all
> *directories*.

## Response

The response to `SHOW DIRECTORY` is a single-column result set:

| Output Column | Description |
| - | - |
| `DDL` | The `CREATE DIRECTORY` statement that would recreate the *directory*, including its configured options |

## Examples

To output the DDL for a *directory*, `kdata`:

```sql SHOW DIRECTORY Example theme={null}
SHOW DIRECTORY 'kdata';
```

```sql SHOW DIRECTORY Output theme={null}
+------------------------------------+
| DDL                                |
+------------------------------------+
| CREATE DIRECTORY 'kdata'
  WITH OPTIONS (
    'data_limit' = '4294967296'
  ) |
+------------------------------------+
```

To output the DDL for all *directories*:

```sql SHOW DIRECTORIES (All Directories) Example theme={null}
SHOW DIRECTORIES *;
```

> [!NOTE]
>
> The DDL for a *home directory* is
> emitted with an empty *directory* name, the owning user being given in a
> `create_home_directory` option instead.


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