Related Topics - Advanced SQL Engine - Teradata Database

SQL Fundamentals
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
zwv1557098532464.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1141
lifecycle
previous
Product Category
Teradata Vantage™
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 .