How to Query System Tables from a Linked Server

Userlevel 3

When you create a linked server in SSMS, the System Tables are not available in the table/view listing, but they can still be accessed and queried.  


To query the System Tables, you will be using the OPENQUERY call, like the example below:  
SELECT * FROM OPENQUERY([Linked Server Name], 'SELECT * FROM sys_tables'); 


If you have additional questions or need any assistance, please reach out to for further help 

This topic has been closed for comments