Results 1 to 2 of 2

Thread: newbie question

  1. 06-05-2003, 01:11 PM #1
    Styles
    Styles is offline Registered User
    Join Date
    Jun 2003
    Location
    NJ
    Posts
    8

    newbie question

    Hi all,
    I was hoping someone could help me out.

    I'm using MS SQL Server 7, the Enterprise Manager. I'm in a DB, and I want to make a new view. I hit the button to see all the tables that I can add from that database, fine. But is there a way to also see tables from other DBs in that same server? I'd like to be able to check the boxes next to the fields I want, establish relationships, etc.

    Thanks in advance!
    Reply With Quote Reply With Quote
  2. 06-05-2003, 03:09 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    The graphical utility only displays tables from the current database.

    You have to use query analyzer to create a view using

    CREATE VIEW

    statement, here you can list tables from multiple databases.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    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