How to rename primary key constraint in SQL Server
<p>I have a PK constraint on table <code>Notes</code> named <code>PK_dbo.Notes</code> and want to rename it to <code>PK_Notes</code> using SQL Server DDL, i.e. not by using SSMS rename menu option.</p>

<p>Mentioned in <a href="https://stackoverflow.com/questions/3729204/how-do-i-rename-my-constraints">another question</a>'s answers queries don't work for me. <a href="https://stackoverflow.com/questions/8712875/sql-server-rename-a-constraint">That thread</a>'s answers are also helpful, but don't work too.</p>