select all tables linked server sql
declare @temp table
(
col1 varchar(255),
col2 varchar(255),
[name] varchar(255),
[type] varchar(255),
col3 varchar(255)
)
insert @temp exec sp_tables_ex 'Your_LinkedServer_Name'
select * from @temp