WHAT IS THE SYSTEM PROCEDURE TO LIST OUT TABLE FROM LINKED SERVER?

Sushant Mishra

Total Post:37

Points:185
Posted by  Sushant Mishra
 178  View(s)
Ratings:
Rate this:
  1. Sushant Mishra

    Post:37

    Points:185
    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



     

      Modified On Mar-29-2018 01:54:33 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!