Sharing Tables 1

[Databaseguy]

is there a way to share tabels between databases on the same server ?

I have two distinct applications. Inventory and EDI. They both have thier own front ends, but are using the same back end. This doesn't make sense because theu should have their own tables and SPs except for a few common tabels. These are UPC, Color, Style, etc.

 

[JohnDTampaBay]

You can reference tables in another database by specifying the four-part table name. If the tables are on the same server the server name is not necessary, only the three-part name is required.

Server.Database.Owner.Table

SELECT rderID, c.Color
FROM MyDB.dbrders o
JOIN YourDB.dbo.Color c ON o.ColorID = c.ColorID

I hope this helps. Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[Databaseguy]

Forgot about that. Cool. Just might work.