17.10 - ALTER FOREIGN TABLE Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
table_option
Any table option allowed for CREATE FOREIGN TABLE (see table_option).
database_name
Name of the database that contains the foreign table.
Default: current database
user_name
Name of the user who owns the foreign table.
Default: current user
table_name
Name of the existing foreign table to alter.
normalize_option
For syntax, see normalizein ALTER TABLE Syntax (Basic). For syntax element description, see NORMALIZE.
period_specification
For syntax, see add_option in ALTER TABLE Syntax (Basic). For syntax element description, see ADD PERIOD FOR.
column
Name of table_name column to alter.
column_2
Name of table_name column other than column. See INTO column_name in ADD column_name.
new_name
New name for column.
data_type_declaration
For syntax, see data_typein CREATE GLOBAL TEMPORARY TRACE TABLE Syntax. For syntax element description, see CREATE GLOBAL TEMPORARY TRACE TABLE Syntax Elements.
data_type_attributes
For syntax, see data_type_attributesin CREATE GLOBAL TEMPORARY TRACE TABLE Syntax. For syntax element description, see CREATE GLOBAL TEMPORARY TRACE TABLE Syntax Elements.
location_column
See location_column.
path_pattern
See PATHPATTERN.
MANIFEST
Specifies whether location_column points to a manifest file. If you specify 'FALSE', location_column points to a key prefix. The key prefix must include the full path and file name.
Default: 'FALSE'
row_format
See ROWFORMAT.
You cannot specify ROWFORMAT with STOREDAS ('PARQUET').
STOREDAS
See STOREDAS.
Default: 'TEXTFILE'
STRIP_EXTERIOR_SPACES
[Optional] Specify whether to strip exterior (leading and trailing) spaces.
STRIP_EXTERIOR_SPACES is disallowed with any of the following:
  • Payload defined with data type DATASET CSV or JSON
  • STOREDAS ('PARQUET')
  • PARTITION BY COLUMN
Default: 'FALSE'
STRIP_ENCLOSING_CHAR
[Optional] Specify either 'NONE' or the enclosing character to skip when there are no exterior spaces. The enclosing_character must be double quotation mark (").
STRIP_ENCLOSING_CHAR is disallowed with any of the following:
  • Payload defined with data type DATASET CSV or JSON
  • STOREDAS ('PARQUET')
  • PARTITION BY COLUMN
Default: 'NONE'
constraint_name
Name of constraint to add to column.
column_constraint
See column_constraint_attribute.