sql2005 删除index错误

[gooood]

错误信息如下.那个表里面的constrain我也全部删除了,怎么还会这样

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for Index 'dd'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Index&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An explicit DROP INDEX is not allowed on index 'dbo.tdChildRiskFactor.dd'. It is being used for UNIQUE KEY constraint enforcement. (Microsoft SQL Server, Error: 3723)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=3723&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

[M1CR0S0FT]

http://topic.csdn.net/t/20030401/10/1602475.html

[想飞的狼]

表里是不是主键不唯一

[wgzaaa]

表中仍有UNIQUE索引'dbo.tdChildRiskFactor.dd'，需要用alter table 删除
alter table tdChildRiskFactor drop constraint dd

[klan]

就用alter table tdChildRiskFactor drop constraint dd了