/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 vote145 views1 answer
How to delay stored procedure execution in sql server
SQL
37 votes127 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote79 views1 answer
Ms sql print more than 1 variable
SQL
0 vote124 views1 answer
Postgres type equivalent to timespan c#
SQL
1 vote120 views1 answer
Create temporal table in sql
SQL
3 votes113 views3 answers
Concatenation in sql
SQL
0 vote123 views1 answer
Mysql database hyphen
SQL
1 vote129 views3 answers
Mysql disable foreign keys check
SQL
1 vote124 views2 answers
Oracle create synonym
SQL
0 vote131 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL