/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

1 vote94 views1 answer
Select random sample sql
SQL
0 vote114 views1 answer
Mysql order by where condition sub query
SQL
-1 vote135 views1 answer
Mysql faster insert
SQL
0 vote102 views1 answer
Get null value in sql
SQL
0 vote110 views1 answer
Oracle date summer time
SQL
0 vote98 views1 answer
Mysql database hyphen
SQL
0 vote124 views1 answer
Synapse sql table set pk
SQL
0 vote96 views1 answer
Mysql select statement after index
SQL
8 votes108 views1 answer
Script to add datafile to tablespace
SQL
32 votes111 views6 answers
How to change column name in sql
SQL