Results 1 to 2 of 2

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

  1. 06-20-2009, 09:05 AM #1
    itraja_anna
    itraja_anna is offline Registered User
    Join Date
    Jun 2009
    Posts
    1

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

    Hi guys,

    Here i have 1 major doubt. how to view or retrieve all tables in SQL server instance (not in database). For Ex. In 1 SQL server instance if i have 6 user databases means, i have to view all tables in there 6 databases using T-SQL. As well as how to view all databases in an multiple SQL server instance. for long time i have this doubt. So please clarify me if any one could.

    Thanks,
    T.Rajasekaran.
    Reply With Quote Reply With Quote
  2. 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