删除主键和新建主键

--查询表的主键
SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME='Allowance_Deduct_Detail'
--去掉主键
Alter table Allowance_Deduct_Detail Drop CONSTRAINT PK_Allowance_Deduct_Detail
--添加主键
Alter table Allowance_Deduct_Detail Add CONSTRAINT PK_Allowance_Deduct_Detail Primary Key (RID)