seed_statement - Advanced SQL Engine - Teradata Database
SQL Data Definition Language Syntax and Examples
- Advanced SQL Engine
- Teradata Database
- Release Number
- September 2020
- English (United States)
- Last Update
- Product Category
- Teradata Vantage™
- 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.
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).