16.20 - Common Table Expression Enhancements - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Release Notes
Publication ID
English (United States)
Last Update

You can use a WITH clause to define one or more common table expressions (CTEs) in derived table and view definitions. CTEs are also referred to as named queries.

Previously, when a WITH clause defined multiple CTEs, a CTE could only reference a subsequent CTE in the WITH clause. Now, a CTE can reference a preceding or subsequent CTE in the WITH clause.


CREATE VIEW statements and derived table definitions can include a WITH clause with backward and forward CTE references.


A CTE cannot indirectly reference itself, that is, circular references are not allowed.

A recursive query cannot reference another recursive query, either directly or indirectly.

If you mix nonrecursive queries with recursive queries in a WITH statement modifier, you must specify all forward CTE references or all backward CTE references. You cannot mix forward CTE references and backward CTE references.

Additional Information

For more information, see:
  • Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
  • Teradata Vantage™ SQL Data Manipulation Language , B035-1146