Categories:

System Functions (System Control)

SYSTEM$CANCEL_QUERY

Cancels the specified query (or statement) if it is currently active/running.

See also:

SYSTEM$CANCEL_ALL_QUERIES

Syntax

SYSTEM$CANCEL_QUERY( <query_id> )

Arguments

query_id

Identifier for the query to cancel. To obtain the ID for a query executed within the last 14 days, log into the web interface and go to the History History tab page.

Usage Notes

Examples

SELECT SYSTEM$CANCEL_QUERY('d5493e36-5e38-48c9-a47c-c476f2111ce5');

+-------------------------------------------------------------+
| SYSTEM$CANCEL_QUERY('D5493E36-5E38-48C9-A47C-C476F2111CE5') |
|-------------------------------------------------------------|
| query [d5493e36-5e38-48c9-a47c-c476f2111ce5] terminated.    |
+-------------------------------------------------------------+