16.20 - Restrictions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Some operations that are permitted on base tables are not permitted on views—sometimes for obvious reasons and sometimes not.

The following set of rules outlines the restrictions on how views can be created and used.

  • You cannot create an index on a view.
  • A view definition cannot contain an ORDER BY clause.
  • Any derived columns in a view must explicitly specify view column names, for example by using an AS clause or by providing a column list immediately after the view name.
  • You cannot update tables from a view under the following circumstances:
    • The view is defined as a join view (defined on more than one table)
    • The view contains derived columns.
    • The view definition contains a DISTINCT clause.
    • The view definition contains a GROUP BY clause.
    • The view defines the same column more than once.