The system stored procedure sp_tables is used to list out the tables available in the current database of the current server. What if you want to know the same that exist in the linked Server? You can use sp_tables_ex
The following returns list of tables available in the specified Server and database
EXEC sp_tables_ex @table_server = 'your_linked_server_name', @table_catalog = 'your_database', @table_type = 'TABLE'
If you want to know about the list of Views
EXEC sp_tables_ex @table_server = 'your_linked_server_name', @table_catalog = 'your_database', @table_type = 'VIEW'
Tags: t-sql, sql_server, tsql, BRH, #TSQL, #SQLServer, sp_tables_ex,
This is great. I am working in an environment with linked servers that have several thousand views. Thanks.