CREATE FOREIGN SERVER | Teradata Connector | Teradata Fabric - CREATE FOREIGN SERVER - Teradata Fabric

Purpose

Creates a foreign server object and associates an import table operator and an export table operator with it.

When you create a server object, you can customize it based on its purpose. You can define multiple server objects for the same remote database, each with different characteristics needed by different users.

Syntax

CREATE FOREIGN SERVER server_name
  [ EXTERNAL SECURITY [ INVOKER | DEFINER ] TRUSTED authorization_name ]
  [ using_option ]
  [ DO IMPORT WITH operator_option [, DO EXPORT WITH operator_option ] ] [;]

Syntax Elements

using_option

USING name (
  { 'value' | scalar_subquery | using_parameter | system_variable }
)

operator_option

[ database_name. ] table_operator using_option