> ## 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 RESOURCE GROUP

<a id="sql-rg-show" />

The DDL statement required to reconstruct any *resource group* can be shown. The
DDL for all *resource groups* in the system can also be shown with a single
command.

```sql title="SHOW RESOURCE GROUP Syntax" theme={null}
SHOW RESOURCE GROUP < <resource group name> | ALL >
```

## Examples

To show the DDL of the **memory\_and\_execution** *resource group*:

```sql SHOW RESOURCE GROUP Example theme={null}
SHOW RESOURCE GROUP memory_and_execution
```

To show the DDL of all *resource groups*:

```sql SHOW RESOURCE GROUP (All Groups) Example theme={null}
SHOW RESOURCE GROUP ALL
```


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