Post reply

when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'.It is being used for FOREIGN KEY constraint enforcement. "

  • August 20, 2009 at 1:18 pm

    #225160

    when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'. It is being used for FOREIGN KEY constraint enforcement."

    even no one using the db.

    Do you know how to fix it or what can I do, This index is defrag and I want to drop it and recreate this index.

  • August 20, 2009 at 1:26 pm

    #1042386

    MAK (8/20/2009)

    when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'. It is being used for FOREIGN KEY constraint enforcement."

    even no one using the db.

    Do you know how to fix it or what can I do, This index is defrag and I want to drop it and recreate this index.

    You will need to find the foreign key that is using this index, drop it first, then you can drop and recreate the index. After doing that, be sure to recreate the foreign key constraint as well.

  • August 20, 2009 at 1:36 pm

    #1042391

    You can use the sp_helpconstraint proc to help you out. The bottom section of the output will be the foreign keys that reference the table.

  • August 20, 2009 at 2:05 pm

    #1042409

    Thanks, but there is any other script to get only particular index dependence

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply