Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dropping a constraint
Message
 
 
To
07/04/2015 10:25:44
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01617939
Message ID:
01617949
Views:
25
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform