大数据表添加主键

时间:2022-08-11 13:42:56
1.ALTER TABLE [DiskPackageRecord].[dbo].[InsiteData] ALTER COLUMN [CONTAINERNAME] nvarchar(255) NOT NULL

第一,确保要设主键的列不为空


2.ALTER TABLE [DiskPackageRecord].[dbo].[InsiteData] ADD PRIMARY KEY ([CONTAINERNAME]);

第二,设置主键列

 

SELECT top 10 *
FROM [DiskPackageRecord].[dbo].[InsiteData] where [CONTAINERNAME] in( select [CONTAINERNAME] FROM [DiskPackageRecord].[dbo].[InsiteData] group by [CONTAINERNAME] having count([CONTAINERNAME])>1)
检查要设主键的列有没有重复列