Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Washington D.C.

    Unanswered: Importing a table from another SQL db

    I'm new to sql server. In access if we want to link to a table in another db we can "Import" the table and access will consider it as its own table (it can be updated and...). How can we do this in SQL Server, I mean to link to another table from another db on the same server so that we can see the table in the diagrams and views?


  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Cross-database foreign key references are not supported so this would not be available in the diagrams wizard. You can createa a view that references a table in another db, just use the three part convention, <db>.<owner>.<table name>
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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