Steve Jones - SSC Editor (7/15/2016)
It's a strange inconsistency, in my mind. We put all objects in sys.objects, except a few like Types. So we can have naming collisions. If you're a C/C++ person, you probably don't care, and you wonder why we don't have procs separate from tables.If you're a consistency person, you think this isn't good since I could have two objects with the same name.
Talking about consistency:
Index names must be unique within a table, unique key names must be unique across the whole database.
_____________
Code for TallyGenerator