Here's an interesting scenario that we recently ran into when developing our SchemaEditor application for Clarify.
In Clarify, the rule is that relation names must be unique within a table, which makes sense. For example, I cannot have two relations named case2site on the case table. The schema editing tools (ddcomp, DD Editor, Dovetail ...