16.20 - Related Topics - 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
For more information about:
  • Indexes, see Indexes. For details on NoPI tables, see No Primary Index (NoPI) Tables.
  • Rules for duplicate rows in a table, see CREATE TABLE in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • For an explanation of the features not available for global temporary base tables, see “CREATE TABLE” in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • The result of an INSERT operation that would create a duplicate row, see INSERT in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
  • The result of an INSERT using a SELECT subquery that would create a duplicate row, see INSERT in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
  • Creating a NoPI table, see the NO PRIMARY INDEX clause for the CREATE TABLE statement in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • Loading data into staging tables from FastLoad, see Teradata® FastLoad Reference, B035-2411.
  • Loading data into staging tables from TPump, see Teradata® Parallel Data Pump Reference, B035-3021.
  • Primary indexes, see Primary Indexes.
  • Secondary indexes, see Secondary Indexes.
  • Individual characteristics of global temporary and volatile tables, see Global Temporary Tables and Volatile Tables.
  • Volatile table limitations, see “CREATE TABLE” in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • Creating a queue table, see “CREATE TABLE (Queue Table Form)” in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • The SELECT AND CONSUME statement, see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
  • How to create an error logging table, see “CREATE ERROR TABLE” in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • Specifying error handling for INSERT … SELECT and MERGE statements, see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
  • Temporal tables, see Teradata Vantage™ Temporal Table Support , B035-1182 and Teradata Vantage™ ANSI Temporal Table Support , B035-1186 .