/SQL/Select all tables linked server sql

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

Similar codes

32 votes346 views6 answers
Sql count where
SQL
9 votes322 views2 answers
Sql limit order by
SQL
20 votes330 views5 answers
Reset auto increment mysql
SQL
0 vote339 views1 answer
Psotgres multiple values
SQL
1 vote366 views1 answer
How to put value in variable mysql
SQL
5 votes353 views1 answer
Sql integer to serial
SQL
0 vote350 views1 answer
Openquery update linked server
SQL
0 vote314 views1 answer
Print orcale
SQL
1 vote313 views1 answer
Real world example of nosql
SQL
0 vote312 views2 answers
How to save result of sqlite query in a table
SQL