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 .