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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access » Remote servers

 

Listing the tables on a remote server

You can view a limited or comprehensive list of all the tables on a remote server using a system procedure.

Prerequisites

None.

Context and remarks

Many.

 List the tables on a remote server
  • 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.

Results

A list of all the tables, or a limited list of tables, is returned.

Next

None.

Example

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;

 See also