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.