HELP FOREIGN | Teradata Connector | QueryGrid - HELP FOREIGN - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem

Purpose

Returns the details of the foreign object that you specify.

  • A foreign server object name returns the list of databases accessible on the server.
  • The name of a database on a foreign server returns the list of tables in the remote database on the server.
  • The name of a table in a remote database on a foreign server returns the list of columns in the remote table on the server.
  • The name of a function in a remote database on a foreign server.

Syntax

HELP FOREIGN {
  SERVER server_name |
  DATABASE db_name@server_name |
  TABLE db_name.table_name@server_name
  FUNCTION db_name.ForeignFunctionName@server_name
}