Javatpoint Logo
Javatpoint Logo

Drop Primary Key

ALTER TABLE statement is used to drop a primary key in SQL Server.



Let's drop a primary key using the ALTER TABLE statement in SQL Server. Here we take "cricketers2" table which has "cricketer_id" as a primary key and "cricketers2_pk" as constraint name.


SQL Drop primary 1
Next TopicSS Foreign Keys

Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA