See the following statements for further information about altering tables or creating join indexes.
- ALTER TABLE (Basic Table Parameters)
- CREATE JOIN INDEX
- In Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144:
- ALTER TABLE
- ALTER TABLE TO CURRENT
- CREATE JOIN INDEX
For further information about the DATE, CURRENT_DATE, or CURRENT_TIMESTAMP functions, see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145.
For further information about column-partitioned tables and join indexes, see CREATE TABLE, Teradata Vantage™ - Database Design, B035-1094, and Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.