DROP PRIMARY KEY CONSTRAINT IN SQL SERVER

Sriramnandha
Posted by Sriramnandha under Sql Server category on | Points: 40 | Views : 1482

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')

Comments or Responses

Login to post response