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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |