17.00 - seed_statement - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
SELECT
SEL
Specifies that the expression to be associated with the column_name list is to select from one or more existing user base tables or views.
See Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 for complete documentation of the SELECT clause.
DISTINCT
Only one row is to be returned from any set of duplicates that might result from a given expression list.
Two rows are considered duplicates only if each value in one is equal to each corresponding value in the other.
The DISTINCT operator is only valid when used within a seed statement.
ALL
All rows, including duplicates, are to be returned in the results of the expression list.
This is the default value.
*
All columns from all tables referenced in the FROM clause are to be returned.
When qualified by table_name, * (asterisk) specifies that all columns of only the user base table or view specified by table_name are to be returned.
View columns are explicitly enumerated when views are defined. If a table is changed after a view is defined, those changes will not appear if the SELECT * construct is used.

seed_statement_selection

expression
A valid SQL expression.
You can specify both aggregate and arithmetic operators in the seed query of a view definition expression, but not in its recursive query.
The presence of aggregates in a view definition renders that view non-updatable.
database_name
user_name
Containing database or user for table_name if something other than the current database or user.
table_name
Name of a user base table or view.
This can itself be a recursive reference in the recursive statement portion of the view definition. You cannot make a reference to a recursive view in the seed statement of the view definition.
Use a table_name.* specification in the select list to define the specific table from which rows are to be returned when two or more tables are referenced in the FROM clause.
You cannot create or replace a view on a queue table (see CREATE TABLE and CREATE TABLE … AS).