RemoveObjectOption Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

API Definition

REPLACE PROCEDURE TDStats.RemoveObjectOptionJSON(
  IN jIn JSON(3000) CHARACTER SET UNICODE,
  OUT jOut JSON(3000) CHARACTER SET UNICODE)

JSON Keys

JSON Key IN/OUT Data Type Description
DatabaseName IN VARCHAR(128) Identifies the database whose option should be removed.
TableName IN VARCHAR(128) Identifies a particular table within DatabaseName on which to remove the option.
ObjectListName IN VARCHAR(128) Specifies a previously defined list of objects on which to remove the option. See related API "CreateObjectList" in ObjectList APIs Syntax.
OptionName IN VARCHAR(64) Name of the option being removed.
Valid values include:
  • 'NoBatching'
NumRemoved OUT INTEGER Number of tables whose specified custom option has been removed and reverted back to the default option.