Restricted Use With SELECT AND CONSUME Statements - Teradata Database

Restricted Use With SELECT AND CONSUME Statements

The subquery that defines the contents of a derived table cannot contain SELECT AND CONSUME statements.

For more information about views, see “CREATE VIEW” in SQL Data Definition Language Syntax and Examples.

For more information about specific statements, see:

“ABORT” on page 277

“DELETE” on page 321

“ROLLBACK” on page 462