/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

2 votes103 views1 answer
How to select first row of database sql
SQL
0 vote113 views1 answer
Create table with float datatype in sql server
SQL
0 vote107 views1 answer
Sql value exists in column
SQL
0 vote106 views1 answer
MySQL INSERT IGNORE Statement
SQL
14 votes100 views3 answers
How to add default constraint in mysql
SQL
0 vote108 views1 answer
Mysql multiple primary keys
SQL
0 vote141 views2 answers
How to login to mysql as normal user in ubuntu
SQL
2 votes117 views1 answer
Mysql id of inserted row
SQL
4 votes101 views6 answers
Second max salary in sql
SQL
0 vote135 views1 answer
Mysql 3 months ago
SQL