/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

0 vote274 views1 answer
AddEntityFrameworkSqlite
SQL
6 votes345 views2 answers
Oracle undotbs usage
SQL
0 vote310 views1 answer
Creating h2 database in relative directory eclopse
SQL
1 vote286 views1 answer
Postgres install unaccent extension
SQL
4 votes293 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote263 views1 answer
Install mysql 8 linux
SQL
0 vote320 views2 answers
Coursera spark sql max count
SQL
0 vote273 views1 answer
A network or instance-specific error sql server
SQL
0 vote308 views1 answer
SQL FROM-Klausel
SQL
0 vote309 views1 answer
Shows all databases created by user in ms sql
SQL