Professional Web Applications Themes

Using a table from seperate database? - Microsoft SQL / MS SQL Server

Howdy, Is it possible to use a table located in one SQL database in another database? I have two databases, DB1 & DB2 DB1 has a table named T1 I'd like to use T1 in DB2, (as well as DB3, DB4, etc...) Is there a way to do this? Is it possible to create a view to do this. Thanks, Jason...

  1. #1

    Default Using a table from seperate database?

    Howdy,

    Is it possible to use a table located in one SQL database in another
    database?

    I have two databases, DB1 & DB2
    DB1 has a table named T1

    I'd like to use T1 in DB2, (as well as DB3, DB4, etc...)

    Is there a way to do this? Is it possible to create a view to do this.

    Thanks,
    Jason


    Jason Reljac Guest

  2. #2

    Default Re: Using a table from seperate database?

    Jason,

    Naming for objects in SQL Server databases is:
    <Server>.<Database>.<Owner>.<ObjectName>

    Working within one server you can ignore the Server name, just as you ignore
    the database name when working within a database.

    Between databases, qualify the name further, e.g.

    SELECT a.* , b.*
    FROM dbo.T1 a
    JOIN OtherDatabase.dbo.T1 b
    ON a.RowId = b.RowID

    Yes, you can create views for this.

    Russell Fields
    "Jason Reljac" <jmr109hotmail.com> wrote in message
    news:%23iQZrrkRDHA.2144TK2MSFTNGP11.phx.gbl...
    > Howdy,
    >
    > Is it possible to use a table located in one SQL database in another
    > database?
    >
    > I have two databases, DB1 & DB2
    > DB1 has a table named T1
    >
    > I'd like to use T1 in DB2, (as well as DB3, DB4, etc...)
    >
    > Is there a way to do this? Is it possible to create a view to do this.
    >
    > Thanks,
    > Jason
    >
    >

    Russell Fields Guest

Similar Threads

  1. #39657 [NEW]: The extended table-specification "database.table" creates errors
    By w dot kaiser at fortune dot de in forum PHP Bugs
    Replies: 5
    Last Post: November 28th, 09:53 AM
  2. #39657 [Opn]: The extended table-specification "database.table" creates errors
    By w dot kaiser at fortune dot de in forum PHP Bugs
    Replies: 0
    Last Post: November 28th, 06:29 AM
  3. Replies: 1
    Last Post: December 27th, 08:44 PM
  4. Replies: 6
    Last Post: August 12th, 09:31 AM
  5. Replies: 4
    Last Post: July 1st, 06:01 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139