/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 vote127 views1 answer
Trim sql oracle
SQL
1 vote134 views1 answer
Add constraint sql
SQL
24 votes130 views2 answers
Alter table delete column
SQL
1 vote142 views1 answer
Input in mysql
SQL
10 votes153 views1 answer
All_dependencies
SQL
6 votes140 views2 answers
Mysql check auto increment value
SQL
0 vote180 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
2 votes152 views1 answer
Mysql trigger after update
SQL
0 vote101 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote132 views1 answer
How to connect postgresql database with java
SQL