Drop Primary KeyALTER TABLE statement is used to drop a primary key in SQL Server. Syntax: Example: 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. Output:
Next TopicSS Foreign Keys
|