Here's a script that I've used in the past to rename all constraints - it can handle Primary Keys, Foreign Keys, Defaults, Unique Constraints and Check Constraints.

http://paulfentonsql.co.uk/2016/01/22/rename-all-constraints/[/url]

This is the script I use. It retains formatting and won't encounter problems with lines splitting mid-command, plus it's easy to filter by trigger type.

DECLARE @t VARCHAR (MAX)

SET @t...