/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

6 votes357 views2 answers
Non relational database
SQL
0 vote352 views1 answer
VSCode SQL Server Connection error
SQL
0 vote375 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote375 views1 answer
Sql where max date
SQL
6 votes371 views2 answers
Mysql concatenate two columns into one
SQL
0 vote375 views1 answer
Is not numeric sql
SQL
2 votes366 views1 answer
Sql server case sensitive search
SQL
0 vote423 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote395 views1 answer
What is metadata in sql
SQL
2 votes321 views2 answers
Select multiple tables mysql
SQL