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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Working with remote servers

Altering remote servers Next Page

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.

[, @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.