ASA SQL User's Guide
  Accessing Remote Data
    Working with remote servers

Listing the remote tables on a server

It may be helpful when you are configuring Adaptive Server Anywhere to get a list of the remote tables available on a particular server. The sp_remote_tables procedure returns a list of the tables on a server.

sp_remote_tables servername
                 [,tablename]
                 [, owner ]
                 [, database]

If tablename, owner, or database is given, 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 an ODBC data source named excel:

sp_remote_tables  excel

Or to get a list of all of the tables in the production database in an ASE named asetest, owned by 'fred':

sp_remote_tables  asetest, null, fred, production

For more information, see sp_remote_tables system procedure.