SQL Server Schema

Brogrim used Ask the Experts™
I have a number of tables that are common across a number of schemas.

What is the best approach

example tblCounty is used across 5 different schemas

Can I include it in 1 schema or do I create 1 schema with all tables that are common to many schemas

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
Awarded 2012
I would suggest to use a common schema for all - I call it - master data.

You can include it in 1 schema.

Schemas help to manage the logical entities separately from one another, but still allow objects to work together where required.

Schemas, offer a convenient way to separate database users from database object owners. They give DBA’s the ability to protect sensitive objects in the database, and also to group logical entities together.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial