Listing the tables on a remote server (SQL)

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

Prerequisites

None.

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.

Example

To get a list of all the tables in a database at the remote server named RemoteSA, owned by GROUPO, execute the following statement:

CALL sp_remote_tables('RemoteSA', null, 'GROUPO');

To get a list of all the tables in the Production database in an Adaptive Server Enterprise server named RemoteASE, owned by Fred, execute the following statement:

CALL sp_remote_tables('RemoteASE', null, 'Fred', 'Production');

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');

Listing the tables on a remote server (SQL)

List the tables on a remote server

See also