Showing results for 
Search instead for 
Did you mean: 

Schema Naming Convention strategy


Does anyone have any good ideas on how to name their schemas and business schemas?

We have different types of schemas - some pull data in externally, but others only use Alias tables from other schemas.  We have some that serve very specific purposes for 1 or 2 users, and others that are used by many because they have common data.

Do you align names between schemas and business schemas so it's easy to tell what goes with what?  

Any ideas are appreciated - our schema list is starting to look rather unorganized, and it'd be good to stop the issue before it gets worse.  Maybe one day we'll be able to copy a schema and rename it, and it'll allow us to rename them in a roundabout way.  😉