Is there a way to point a foreign key to a table in other Db

[AndrewMBaines]

You could access the multiple databases as one:

Multiple databases in one question without a data warehouse- YES YOU CAN!

I've been meaning to test this idea for a while, finally found the time today. If there's enough interest and people struggle with this, I'll do a proper 'How To'. First the bad news (for some of you). You need Windows. Get over it! I'm not including details of any security settings to keep stuff clearer. Install SQL Server Express (2016 or 2017). This is the free edition, only limitation is the database size of 10GB. As we're not storing any data, that's not a …