新增聚集唯一索引

--聚集唯一
USE hisdb
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE name = N'DATA_MZPatFeeDetail_UC_Index1' and id = object_id(N'DATA_MZPatFeeDetail'))
BEGIN
CREATE UNIQUE CLUSTERED INDEX DATA_MZPatFeeDetail_UC_Index1 ON DATA_MZPatFeeDetail(PatFeeID)
END
GO

原文地址:https://www.cnblogs.com/LuckyNick/p/4135502.html