You can view a limited or comprehensive list of all the tables on a remote server using a system procedure.
Context and remarks
Call the sp_remote_tables system procedure to return a list of the tables on a remote server.
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, execute the following statement:
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, execute the following statement:
CALL sp_remote_tables asetest, null, fred, production;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|