Post reply

List of table in Linked Server

  • July 6, 2007 at 3:00 pm

    #69842

    Is there a way that you can query the list of the tables in one of your linked server?

  • July 6, 2007 at 7:39 pm

    #717817

    SELECT * FROM LnkdSrv.DbName.dbo.SysObjects WHERE XType = 'U' ORDER BY Name

  • July 7, 2007 at 11:23 pm

    #717859

    Noelson,

    Check out sp_table_ex in Books Online.  It will do exactly what you are trying to accomplish, and works for non-SQL Linked servers as well:

    sp_tables_ex

    Returns table information about the tables from the specified linked server.

    Let me know if you need more detail.

    Scott Thornburg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply