/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 vote187 views1 answer
Oracle create package specification
SQL
0 vote203 views1 answer
SAP Return
SQL
1 vote181 views1 answer
Oracle rolling back
SQL
0 vote174 views1 answer
Suse start MySQL
SQL
0 vote184 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote198 views1 answer
Postgresql pass array in function
SQL
0 vote210 views1 answer
Insert value in identity
SQL
5 votes210 views4 answers
Traduction
SQL
0 vote181 views1 answer
Increment id in mysql
SQL
0 vote206 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL