Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.