Related Information - Advanced SQL Engine - Teradata Database

SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
uhe1592872955107.ditamap
dita:ditavalPath
uhe1592872955107.ditaval
dita:id
B035-1141
lifecycle
previous
Product Category
Teradata Vantage™
  • 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 Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
  • Creating a queue table, see 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 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.