Skip to main content
Outputs the DDL statement required to reconstruct the given SQL-GPT context.
SHOW CONTEXT Syntax
The response to SHOW CONTEXT is a single-column result set with the DDL statement as the value in the CONTEXT_DEFINITION column.

​
Parameters

<schema name>

Name of the schema containing the SQL-GPT context to show

<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:
SHOW CONTEXT Example
To output the DDL for all SQL-GPT contexts:
SHOW CONTEXT (All Contexts) Example