RemoveObjectList | Application Programming Reference | Teradata Vantage - RemoveObjectList - Teradata Vantage - Analytics Database

Application Programming Reference
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
qld1628112131956.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ajo1472244909562
lifecycle
latest
Product Category
Teradata Vantage™

Removes a named object list and all of its entries.

Syntax

REPLACE PROCEDURE TDSTATS.RemoveObjectList (
  IN ObjectListName VARCHAR(128) CHARACTER SET UNICODE, 
  IN ObjectListId BIGINT,
  OUT NumRemoved INTEGER
)
  ...
;

Syntax Elements

ObjectListName
Name of the existing object list. This list may contain both databases and fully qualified tables.
This input parameter cannot be NULL.
ObjectListId
ID of the existing object list to remove.
This input parameter cannot be NULL.
NumRemoved
Number of the database and table entries that were in the removed list.

Usage Notes

You can view object list data in the TDSTATS.ObjectList and TDSTATS.ObjectListEntry tables. The names of the object lists are stored in the TDSTATS.ObjectList.ListName column.

Example: Using RemoveObjectList

The following example shows how to remove the newly created object list named FinCashList and its entries.

CALL TDSTATS.CreateObjectList('FinCashList',ObjectListId);
CALL TDSTATS.AddObjectListEntry('FinCashList',NULL,'Fin%',NULL);
CALL TDSTATS.AddObjectListEntry('FinCashList',NULL,'Account%','Cash%');
CALL TDSTATS.RemoveObjectList('FinCashList',NULL,NumRemoved);