# How to Query System Tables from a Linked Server

**URL:** <https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754>\
**Category:** Editions\
**Tags:** article, odbc, ssms\
**Created:** [June 7, 2024, 9:14pm UTC](https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754 "2024-06-07T21:14:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cameron\_L](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\
**Post date:** [June 7, 2024, 9:14pm UTC](https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754/1 "2024-06-07T21:14:20Z")

</div>

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: &nbsp;  
&nbsp;  
SELECT \* FROM OPENQUERY([Linked Server Name], ‘SELECT \* FROM sys\_tables’);

If you have additional questions or need any assistance, please reach out to [support@cdata.com](mailto:support@cdata.com) for further help
