>I am dropping a constraint from a table, the primary key, so I can reindex it. Is it normal this operation takes minutes to execute? If yes, can someone explain why this is like that and what kind of process is being executed in the background?
You didn't provide enough information to answer you question. Is PK clustered? Are there other indexes?
--sb--