-- Schema: sales -- Table: customer -- primary key column: customerid ALTER TABLE sales.customer ADD CONSTRAINT PK_customer_customerid PRIMARY KEY NONCLUSTERED (customerid) NOT ENFORCED;