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.

Task
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.

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

Parent topic: Remote Servers