Suppose I would like to have a common table for two schema's, is that possible?
A table has it's schema in it's fully qualified name, e.g. [dev].[product] so it looks like this is not possible.
How could I make the data in table [common].[types] (and not a copy) available to schema [dev]? A view perhaps?
One more question: how about relationships that span schema's - to what schema would this relationship (have to? / best?) belong?