Results 1 to 2 of 2

Thread: How to find all tables in SQL server using T-SQL

Threaded View

  1. 06-20-2009, 08:02 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You have to view all dbs on remote instance with t-sql via linked server, view all tables by querying information_schema.tables in each db.
    Last edited by rmiao; 06-20-2009 at 08:06 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules