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

Total Post:37

Points:185
 316  View(s)
Ratings:
Rate this:
  1. 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!