SQLServer修改主键

TRUNCATE TABLE reports_Transformations_Months
ALTER table reports_Transformations_Months DROP CONSTRAINT PK_reports_Transformations_Months;
ALTER table reports_Transformations_Months 
ADD CONSTRAINT PK_reports_Transformations_Months PRIMARY KEY(Id,Eid,AreaId,IndustryId);

注：清空数据，清除主键，重新定义主键（多个主键）

感谢：https://blog.csdn.net/onexin_smile/article/details/82022426