DROP PRIMARY KEY CONSTRAINT IN SQL SERVER

CREATE TABLE PRODUCTDETAILS(PRODUCT_ID INT

CONSTRAINT PK_PRODUCTID PRIMARY KEY(PRODUCT_ID),PRODUCTNMAE VARCHAR(90),

PRODUCTPRICE MONEY,VENDORNAME VARCHAR(90))



ALTER TABLE PRODUCTDETAILS DROP CONSTRAINT PK_PRODUCTID

INSERT INTO PRODUCTDETAILS VALUES(1,'SDS',323,'DSDS')