A. Because the index is built as part of a constraint, the way to drop it is to drop the constraint :- ALTER TABLE <tablename> DROP CONSTRAINT ....
Jul 29: High Availability and Disaster Recovery with SQL Server 2014 AlwaysOn Availability Groups with Michael Otey
Jul 30: Designing a Mobile Dashboard Solution with Microsoft DataZen with Paul Turley
Jul 30 @ 12pm EDT: A Checklist for Making Smart Technology Investments
Aug 5 @ 12pm EDT: From Spiraling Costs to Streamlined IT: The Journey to Invisible Infrastructure
Aug 11 @ 12pm EDT: How to Detect SQL Injection & XSS Attacks with AlienVault USM
Aug 19 @ 12pm EDT: Small Business: Assess Your Technology to Ensure Your Operation Isn’t at Risk
View the complete online training catalog
Tweets about @WindowsITPro
To submit an article, please log in and then click Contribute. If you are not a registered user on Windows IT Pro, click Register.
All Sponsored Blogs
The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.
Sponsored Introduction Continue on to (or wait seconds) ×