This Blog

Home
Contact

Common Tasks

Syndication

RSS
Atom
Comments RSS
Receive Email Updates
Subscribe

SQL Server (T-SQL)

Comments and notes on SQL Server 2000, 2005, and T-SQL

An explicit DROP INDEX is not allowed on index 'drive.ix_drives'. It is being used for UNIQUE KEY constraint enforcement

After issuing this command:

 


DROP index drive.ix_drives

I get this message:

An explicit DROP INDEX is not allowed on index 'drive.ix_drives'. It is being used for UNIQUE KEY constraint enforcement.

Then answer was to issue this command:

 


ALTER TABLE drive DROP CONSTRAINT ix_drives

Published May 07 2008, 10:49 AM by Steve Gray | [Edit Post]

[Edit Tags]

Comments

No Comments

About Steve Gray

Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.