In a given database what objects (Table, View, Index, Constraint, Trigger etc) can or can't have the same name?
So a table or view can have the same name if they are in a different schema. Is this true of other database objects?
For example, can an index have the same name of another if it is in another schema or for another table?
What are the rules for uniqueness around identifiers? (Not what we should do or naming conventions, but rather what is valid to do)