How to rename primary key constraint in SQL Server
28,335
Sometimes you need to explicitly wrap names in square brackets, like this:
sp_rename @objname = N'[Notes].[PK_dbo.Notes]', @newname = N'PK_Notes'
I think it's because of the dot in PK name.
Also, as you see, PK constraints don't need @objtype = 'OBJECT' to be specified.
Related videos on Youtube
15 : 24
SQL PRIMARY KEY CONSTRAINT AND CLUSTERED INDEX | STEP BY STEP SOLUTION TO SQL INTERVIEW QUESTION
02 : 33
SQL PRIMARY KEY Constraint | SQL Server Tutorial for Beginners
24 : 13
Working with Primary & Foreign key Constraint in SQL Server | SQL Server Tutorial
07 : 59
how to add and drop primary key in sql server 2008 and 2012
11 : 21
SQL-12A: Ràng buộc PRIMARY KEY trong SQL Server.
10 : 57
How to add Foreign key Constraint to existing table in SQL Server-SQL Server/TSQL Tutorial Part 68
![Bài 2: [Học SQL từ đầu] - Update table name, column name, data type, primary key, foreign key](https://i.ytimg.com/vi/XD8nJYaKEuM/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBvdKJAV9UVdJIS68Qq2ceoB9-kVg)
14 : 40
Bài 2: [Học SQL từ đầu] - Update table name, column name, data type, primary key, foreign key
08 : 57
SQL Tutorial - PRIMARY KEY CONSTRAINTS
04 : 04
HOW TO DROP PRIMARY KEY IN SQL SERVER | AMJAD ALI | IN HINDI/URDU
10 : 51
Create, Alter, Drop Primary key constraint in SQL Server - Part 13
Author by
pkuderov
I am a computational cognitive neuroscience / reinforcement learning researcher with a lifetime goal of creating artificial intelligence.
Updated on January 09, 2020Comments
-
pkuderov over 4 years
I have a PK constraint on table
NotesnamedPK_dbo.Notesand want to rename it toPK_Notesusing SQL Server DDL, i.e. not by using SSMS rename menu option.Mentioned in another question's answers queries don't work for me. That thread's answers are also helpful, but don't work too.