select all tables linked server sql

Solutions on MaxInterview for select all tables linked server sql by the best coders in the world

showing results for - "select all tables linked server sql"
Axel
13 Jul 2016
1declare @temp table
2(
3    col1 varchar(255),
4    col2 varchar(255),
5    [name] varchar(255),
6    [type] varchar(255),
7    col3 varchar(255)
8)
9insert @temp exec sp_tables_ex 'Your_LinkedServer_Name'
10select * from @temp
similar questions
queries leading to this page
select all tables linked server sql