How to DROP a PRIMARY KEY in MS SQL Server
Sometimes you may need to drop or delete primary key of a table in MS SQL Server. You can drop a primary key in SQL Server using the ALTER TABLE statement.
Let’s create a table first to demonstrate the example.
CREATE TABLE [DataAnalytics].[dbo].[tblt_emp] ( id BIGINT NOT NULL, emp_name VARCHAR(50) NOT NULL, dob DATE, age FLOAT, income DECIMAL(10,2), remarks NVARCHAR(500), CONSTRAINT pk_tblt_emp_id PRIMARY KEY(id) );
The syntax to drop a primary key using the ALTER TABLE statement in SQL Server is:
ALTER TABLE table_name DROP CONSTRAINT constraint_name;
Let’s look at an example of how to drop a primary key using the ALTER TABLE statement in MS SQL Server.
ALTER TABLE [DataAnalytics].[dbo].[tblt_emp] DROP CONSTRAINT pk_tblt_emp_id;
After executing the above statement you will see a successful message of executing the drop constraint statement.
I have an another tutorial similar to this tutorial where you will learnĀ How To DISABLE a PRIMARY KEY in MS SQL Server.
In this tutorial, I have shown how to drop primary key in MS SQL Server. Hope you have enjoyed the tutorial. If you want to get updated, like my facebook page http://www.facebook.com/freetechtrainer and stay connected.