Results 1 to 2 of 2

Thread: Database Tables

  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: Database Tables

    I don't know if this is possible, if you have 5 database in the same server and they all have a table called e.g sysfile. What will be the sql to select statement to select everything from syfile of the 5 databases without naming the database, the reason is i want to this track down in case another database is added i don't need to manually check this

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Use table sysdatabases and create dynamic query.

Posting Permissions

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