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
}