from_option - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

You can specify the following options.

TEMPORARY
The name of the global temporary source table from which statistics are to be copied to the target table.
database_name
The containing database for the table_name_2, join_index_name, or hash_index_name, if other than the default database.
user_name
The containing user for the table_name_2, join_index_name, or hash_index_name, if other than the default database.
table_name_2
The name of the base source table from which statistics are to be copied to the target table.
join_index_name
The name of the join index for which statistics are to be collected.
hash_index_name
The name of the hash index for which statistics are to be collected.
column_name_3
The column name set, partition, or index for which statistics are to be copied from the source table to the target table.
PARTITION
The column name set, partition, or index for which statistics are to be copied from the source table to the target table.