RemoveQueryList | Application Programming Reference | Teradata Vantage - 17.10 - RemoveQueryList - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Deletes a query list previously created by AddQueryList along with all of its entries.

Syntax

REPLACE PROCEDURE TDSTATS.RemoveQueryList (
  IN QueryListName VARCHAR(128) CHARACTER SET UNICODE,
  OUT NumRemoved   INTEGER
)
  ...
;

Syntax Elements

QueryListName
Name of the existing query list created by a call to AddQueryList. For more information, see AddQueryList.
This input parameter cannot be NULL.
NumRemoved
Number of query entries removed along with the specified list.

Usage Notes

To remove only an individual query entry from a list, you must call the RemoveQueryListEntry external stored procedure.

You can view the query list data in the TDSTATS.QueryList and TDSTATS.QueryListEntry tables and the names of the query lists in the TDSTATS.QueryList.ListName column.

Example: Using RemoveQueryList

The following example shows how to remove the query list named MySlowQueries.

CALL TDSTATS.RemoveQueryList('MySlowQueries',NumRemoved);

Related Information

For more information on .... See ...
previous created query lists AddQueryList.
removing an individual query entry from a list RemoveQueryListEntry.