SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create table Product (
    [Id] int primary key not null,
    [Name] varchar (250),
    [Price] money
);
DECLARE @SQL NVARCHAR(MAX);

SELECT @SQL = 'ALTER TABLE Product '+ 
              ' DROP CONSTRAINT ' + name + ';'
FROM sys.key_constraints
WHERE [type] = 'PK'
AND [parent_object_id] = OBJECT_ID('Product');

EXEC sp_executeSQL @SQL;
-- Make sure if you have some rows where Name is NULL to update your table
ALTER TABLE Product ALTER COLUMN Name varchar (250) NOT NULL;
ALTER TABLE Product ADD constraint PK_Products PRIMARY KEY(Id, Name);
SELECT *
FROM sys.key_constraints
WHERE [type] = 'PK'
AND [parent_object_id] = OBJECT_ID('Product');


name
object_id
principal_id
schema_id
parent_object_id
type
type_desc
create_date
modify_date
is_ms_shipped
is_published
is_schema_published
unique_index_id
is_system_named
is_enforced


PK_Products
613577224
null
1
581577110
PK
PRIMARY_KEY_CONSTRAINT
2026-05-07 17:12:21.430
2026-05-07 17:12:21.430
False
False
False
1
False
True