Skip to main content
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.
SHOW RESOURCE GROUP Syntax

Examples

To show the DDL of the memory_and_execution resource group:
SHOW RESOURCE GROUP Example
To show the DDL of all resource groups:
SHOW RESOURCE GROUP (All Groups) Example