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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Accessing remote data » Working with remote servers

 

List 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 you specify table-name or table-owner, the list of tables is limited to only those that match.

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

CALL sp_remote_tables  excel;

Or to get a list of all 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.