17.00 - ON Clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

Specifies the table, join index, or hash index.

TEMPORARY
The SQL create text or the SQL create text and the collected statistics are to be displayed is for a global temporary table.
database_name
user_name
Name of the containing database or user for database_object_name.
table_name_1
Name of one of the following database objects whose summary statistics and, optionally, detailed statistics are to be reported.
join_index_name
Name of join index whose summary statistics and, optionally, detailed statistics are to be reported.
hash_index_name

Name of the hash index whose summary statistics and, optionally, detailed statistics are to be reported.