17.00 - WITH DELETE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Delete any row whose row partition number evaluates to null or to a value outside the valid range.

The WITH DELETE clause is sometimes referred to as a null partition handler. You cannot specify a null partition handler for a join index.