Schema Naming Convention strategy

[mike_mascitti]

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.  😉 

[RADSr]

@mike_mascitti  - please give this an upvote!  

https://community.incorta.com/t5/product-ideas/allow-developers-to-copy-a-schema/idi-p/638

[Tristan]

Hi Mike,

I know this is way late when it comes to responding, but I only just saw your question.  Have you seen these articles?

• Physical Schema Naming
• Business Schema Naming

Tristan