17.00 - seed_statement - 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)
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.
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 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.


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.
Containing database or user for table_name if something other than the current database or user.
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).