Rename a constraint in SQL Server?

After some more digging, I found that it actually has to be in this form:

EXEC sp_rename N'schema.MyIOldConstraint', N'MyNewConstraint', N'OBJECT'

sql sql-server constraints

You can rename using sp_rename using @objtype = 'OBJECT'

This works on objects listed in sys.objects which includes constraints

sql sql-server constraints

You can use sp_rename.

sp_rename 'CK_Ax', 'CK_Ax1'

CodeHunter