ALTER FOREIGN TABLE Syntax Elements - Advanced SQL Engine - Teradata Database
SQL Data Definition Language Syntax and Examples
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- ft:locale
- en-US
- ft:lastEdition
- 2021-07-27
- dita:mapPath
- spp1591731285373.ditamap
- dita:ditavalPath
- spp1591731285373.ditaval
- dita:id
- B035-1144
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- 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.