ALTER FOREIGN TABLE構文 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/spp1591731285373.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage
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 ]