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

<a id="sql-gpt-show-context" />

Outputs the DDL statement required to reconstruct the given
[SQL-GPT context](/content/sql/sqlgpt/create-context#sql-gpt-create-context).

```sql title="SHOW CONTEXT Syntax" theme={null}
SHOW CONTEXT < [<schema name>.]<context name> | * >
```

<Info>
  The response to `SHOW CONTEXT` is a single-column result set
  with the DDL statement as the value in the `CONTEXT_DEFINITION` column.
</Info>

## Parameters

<AccordionGroup>
  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *SQL-GPT context* to show
  </Accordion>

  <Accordion title="<context name>" id="<context-name>" defaultOpen>
    Name of the existing *SQL-GPT context* for which the DDL will be output; use `*` instead of
    *schema*/*context* name to output the DDL of all *contexts*
  </Accordion>
</AccordionGroup>

## Examples

To output the DDL for a *SQL-GPT context*, `example.atc_ctx`:

```sql SHOW CONTEXT Example theme={null}
SHOW CONTEXT example.atc_ctx
```

To output the DDL for all *SQL-GPT contexts*:

```sql SHOW CONTEXT (All Contexts) Example theme={null}
SHOW CONTEXT *
```


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