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

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

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

> [!NOTE]
>
> The response to `SHOW CONTEXT` is a single-column result set
> with the DDL statement as the value in the `CONTEXT_DEFINITION` column.

## Parameters

> [accordion] \<schema name>
>
> Name of the *schema* containing the *SQL-GPT context* to show

> [accordion] \<context name>
>
> 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*

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