• Wangkhar,

    With the correct scripting or migration tools, explicit constraint names aren't necessary.  I don't object to constraint naming conventions - but I find that for a team of developers and dbas, they are difficult to enforce.  I try to focus on tables, views, stored procedures, and other major object types instead.  If you have the environment control to keep constraint-level names standardized - I envy you.