Can you create relationships between tables in different databases?

[mojoT]

I have about 6 databases that I've made/making and some tables are required in more than one database.

These tables, which are used primarily as lookup tables for combo boxes etc, are hardly ever updated.

We're looking at creating a common database to store those tables that are needed by more than one module. My question is, can you create a relationship between two tables if they're in different databases? And, if you can, how is it done?

I do realise that you don't need to create relationships if your code is written properly, but the bosses want the relationships.

Any feedback would be greatly appreciated.

 

[JayKusch]

The can be no referential integrity between databases.

Thanks

J. Kusch

 

[mojoT]

Is that in all databases, or just SQL Server? And why can't you? If I have a reason, then maybe I can justify it to my boss

 

[vongrunt]

Cross-database referential integrity constraints are implemented in some other databases but not in SQL Server.

AFAIK you can use triggers (FOR UPDATE, DELETE in common database, eventually FOR INSERT, UPDATE in foreign databases) to get the same functionality.