Eitan Blumin gives everything a name:
This article was published by Aaron Bertrand a few years ago, talking about system-named constraints in SQL Server.
The article mostly focuses on the issue of naming conventions as the main issue with system-named constraints and provides a useful stored procedure script to generate sp_rename commands for all system-named constraints.
However, the script in the article provides the solution for only one database and doesn’t support the new “Edge Constraints” that were introduced in SQL Server 2019.
Check out Aaron’s article and Eitan’s follow-up piece.