新增聚集唯一索引

--聚集唯一
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

posted @ 2014-12-01 17:07  LuckyNick  阅读(107)  评论(0编辑  收藏  举报