We have thre projects that are having databases designed for. All of these
have a common set of tables (Human Resources, Facilities, States, etc). I w
ould like to build each of these database seperately, but share these common
tables among all three pro
jects.
While I know we can join tables between databases, I would like to work with
these in the diagram designer. Is there anyway to accomplish this?You can create views in each DB that reference the common tables in
another DB. I don't think there's any way to show tables from another
database in EM's diagram tool though. Best use a grown-up diagram app
such as MS Visio.
David Portas
SQL Server MVP
--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment