thanks, it give me An explicit DROP INDEX is not allowed on index 'Application.PK_dbo.Application'. It is being used for PRIMARY KEY constraint enforcement. (Maybe what I am asking for is not possible)
–
Ian RingroseMar 1 '10 at 9:09

I think you would have to drop the primary key constraint to drop PK indexes. You can use something like... 'ALTER TABLE TableName DROP CONSTRAINT pk_Name'. Remember this will affect referential integrity.
–
DolbzMar 1 '10 at 9:20