--提示很明显了,换个索引名试试: ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_2] UNIQUE NONCLUSTERED ( [TopicCode], [CourseID] ) ON [PRIMARY]
ALTER TABLE [dbo].[Topic_Code_T] DROP CONSTRAINT [Topic_Code_T_Index_1] GO ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_1] UNIQUE NONCLUSTERED ( [TopicCode], [CourseID] ) ON [PRIMARY]
ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_10] UNIQUE NONCLUSTERED ( [TopicCode], [CourseID] ) ON [PRIMARY] --改一下这个索引的名字..应该可以了!
-- 存在相同的索引 要么删除 drop index Topic_Code_T.Topic_Code_T_Index_1ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_1] UNIQUE NONCLUSTERED ( [TopicCode], [CourseID] ) ON [PRIMARY]
--如果已经存在同名索引则先删除 IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Topic_Code_T]') AND name = N'Topic_Code_T_Index_1') ALTER TABLE [dbo].[Topic_Code_T] DROP CONSTRAINT [Topic_Code_T_Index_1] GO --创建索引 ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_1] UNIQUE NONCLUSTERED ( [TopicCode], [CourseID] ) ON [PRIMARY]
ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_2] UNIQUE NONCLUSTERED
(
[TopicCode],
[CourseID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_1] UNIQUE NONCLUSTERED
(
[TopicCode],
[CourseID]
) ON [PRIMARY]
ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_10] UNIQUE NONCLUSTERED
(
[TopicCode],
[CourseID]
) ON [PRIMARY] --改一下这个索引的名字..应该可以了!
-- 存在相同的索引 要么删除
drop index Topic_Code_T.Topic_Code_T_Index_1ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_1] UNIQUE NONCLUSTERED
(
[TopicCode],
[CourseID]
) ON [PRIMARY]
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Topic_Code_T]')
AND name = N'Topic_Code_T_Index_1')
ALTER TABLE [dbo].[Topic_Code_T] DROP CONSTRAINT [Topic_Code_T_Index_1]
GO
--创建索引
ALTER TABLE [dbo].[Topic_Code_T] ADD CONSTRAINT [Topic_Code_T_Index_1] UNIQUE NONCLUSTERED
(
[TopicCode],
[CourseID]
) ON [PRIMARY]