Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Listing the remote tables on a server

When configuring SQL Anywhere to get a list of the remote tables available on a particular server, it may be helpful to use the sp_remote_tables system procedure. The sp_remote_tables procedure returns a list of the tables on a remote server.

sp_remote_tables(
@server-name
[, @table-name
[, @table-owner
[, @table-qualifier
[, @with-table-type ] ] ] ]
)

If table-name or table-owner,is specified, the list of tables is limited to only those that match.

For example, to get a list of all of the Microsoft Excel worksheets available from a remote server named excel:

CALL sp_remote_tables  excel;

Or to get a list of all of the tables in the production database in an Adaptive Server Enterprise server named asetest, owned by fred:

CALL sp_remote_tables  asetest, null, fred, production;

For more information, see sp_remote_tables system procedure.