You can view a limited or comprehensive list of all the tables on a remote server using a system procedure.
None.
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.