---
title: "What is the System Procedure to List out Table from Linked Server?"  
description: "What is the System Procedure to List out Table from Linked Server?"  
author: "Sushant Mishra"  
published: 2017-09-18  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23302/what-is-the-system-procedure-to-list-out-table-from-linked-server  
category: "database"  
tags: ["sql server", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# What is the System Procedure to List out Table from Linked Server?

It return the list of table from the database you can also use it for view you have to pass view name in table type

```
  EXEC sp_tables_ex@table_server        ='your_linked_server_name', @table_catalog     ='Sample', @table_type        = 'SignIn'
```

\

You have to give database name in table catalog and table name or view name in

\

table type\

\

\

## Answers

### Answer by Sushant Mishra

It return the list of table from the database you can also use it for view you have to pass view name in table type

```
  EXEC sp_tables_ex@table_server        ='your_linked_server_name', @table_catalog     ='Sample', @table_type        = 'SignIn'
```

\

You have to give database name in table catalog and table name or view name in

\

table type\

\

\


---

Original Source: https://www.mindstick.com/interview/23302/what-is-the-system-procedure-to-list-out-table-from-linked-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.