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.