DROP PROMPT

The DROP PROMPT statement is used to delete an existing prompt. This statement can optionally specify the CASCADE keyword to remove dependent models as well.

Syntax

DROP PROMPT prompt_name [CASCADE];

Options

Option	Description	Possible Values	Mandatory
prompt_name	The name of the prompt to be dropped.	String	Yes
CASCADE	If specified, automatically drops models that depend on the prompt.	N/A	Optional

Example

Here is an example of a DROP PROMPT statement:

DROP PROMPT generate_sql_prompt CASCADE;

Description of Example

• prompt_name: The name of the prompt to be dropped is generate_sql_prompt.
• CASCADE: The CASCADE option indicates that any models dependent on the generate_sql_prompt will also be dropped.

This example demonstrates how to use the DROP PROMPT statement to delete the generate_sql_prompt and all dependent models by specifying the CASCADE option.