ALTER FOREIGN TABLE Syntax | Teradata Vantage - 17.10 - ALTER FOREIGN TABLE Syntax - 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)
ALTER FOREIGN TABLE table_specification 
  [ , table_option [,...] ]
  [ , external_security_clause ] 
  [ column_option ]
  [ UPDATE update_specification ]
table_specification
[ database_name. | user_name. ] table_name
external_security_clause
EXTERNAL SECURITY [ { INVOKER | DEFINER } TRUSTED ]
  [ database_name.| user_name.]authorization_name
column_option
{ ADD { column change |
        (named_column_specification [,...]) INTO column_2 |
        [ COLUMN | ROW ] (named_column_specification [,...]) [ [NO] AUTO COMPRESS ] |
        [ COLUMN | ROW | SYSTEM ] (column) [ [NO] AUTO COMPRESS ]
  } |
  DROP column [ IDENTITY ] |
  RENAME column { AS | TO } new_name
}
update_specification
{ [ LOCATION (location_column) ]
  [ PATHPATTERN (path_pattern) ]
  [ MANIFEST [ ({ 'TRUE' | 'FALSE' }) ] ]
  [ ROWFORMAT [ (row_format) ] ] 
  [ STOREDAS [ ({ 'TEXTFILE' | 'PARQUET' }) ] ]
  [ STRIP_EXTERIOR_SPACES [ ({ 'TRUE' | 'FALSE' }) ] ]
  [ STRIP_ENCLOSING_CHAR [ ({ 'NONE' | '"' }) ] ]
}
change
{ nameless_column_specification [ INTO column_2 ] |
  data_type_attributes |
  [ CONSTRAINT constraint_name ] column_constraint |
  NULL |
  security_constraint_column_declaration |
}
named_column_specification
column data_type_declaration [ data_type_attributes ]
nameless_column_specification
data_type_declaration [ data_type_attributes ]