16.10 - Related Topics - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)
Last Update
2018-04-25

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 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 SQL Data Definition Language - Syntax and Examples, B035-1144.
  • The result of an INSERT operation that would create a duplicate row, see INSERT in SQL Data Manipulation Language , B035-1146 .
  • The result of an INSERT using a SELECT subquery that would create a duplicate row, see INSERT in SQL Data Manipulation Language , B035-1146 .
  • Creating a NoPI table, see the NO PRIMARY INDEX clause for the CREATE TABLE statement in SQL Data Definition Language - Syntax and Examples, B035-1144.
  • Loading data into staging tables from FastLoad, see Teradata FastLoad Reference.
  • Loading data into staging tables from TPump, see Teradata Parallel Data Pump Reference.
  • 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 SQL Data Definition Language - Syntax and Examples, B035-1144.
  • Creating a queue table, see “CREATE TABLE (Queue Table Form)” in SQL Data Definition Language - Syntax and Examples, B035-1144.
  • The SELECT AND CONSUME statement, see SQL Data Manipulation Language , B035-1146 .
  • How to create an error logging table, see “CREATE ERROR TABLE” in SQL Data Definition Language - Syntax and Examples, B035-1144.
  • Specifying error handling for INSERT … SELECT and MERGE statements, see SQL Data Manipulation Language , B035-1146 .
  • Temporal tables, see Temporal Table Support , B035-1182 and ANSI Temporal Table Support , B035-1186 .