Set Operators in View Definitions - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-12-13
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantageā„¢

Set operators are permitted within view definitions.

For example, the following REPLACE VIEW statement uses UNION within a view definition:

REPLACE VIEW view_1 AS 
   SELECT x1,y1 
   FROM table_1 
   UNION 
   SELECT x2,y2 
   FROM table_2;