17.10 - CREATE FOREIGN TABLE構文 - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1144-171K-JPN
Language
日本語 (日本)
CREATE [MULTISET] FOREIGN TABLE table_specification 
  [ , table_option [,...] ]
  [ , external_security_clause ]
  [ ( location_column, { payload_column | data_column_definition }) ]
  USING (
    LOCATION ( 'external_file_path' ) 
    [ PATHPATTERN ( 'value' ) ]
    [ MANIFEST ( { 'TRUE' | 'FALSE' } ) ] 	
    [ ROWFORMAT ( 'encoding_format' ) ]
    [ STOREDAS ( { 'TEXTFILE' | 'PARQUET' } )]
    [ HEADER ( { 'TRUE' | 'FALSE' } ) ]
    [ STRIP_EXTERIOR_SPACES ( { 'TRUE' | 'FALSE' } ) ]
    [ STRIP_ENCLOSING_CHAR ('NONE') ]
  )
  [ [,] NO PRIMARY INDEX ] 
  [ [,] PARTITION BY COLUMN ] [;]
table_specification
[database_name. | user_name.] table_name
external_security_clause
EXTERNAL SECURITY [ { INVOKER | DEFINER } TRUSTED ]
  [ database_name.| user_name.]authorization_name

指定された列の総数は2048を超えることはできません。