Solved

An explicit DROP INDEX is not allowed on index

Posted on 2010-08-13
2
756 Views
Last Modified: 2012-05-10
I need to remove the PK, but the drop gives error. There should be a way to remove the PK, not?
"
An explicit DROP INDEX is not allowed on index 'dbo.tblTracker.UniqTracker'. It is being used for PRIMARY KEY constraint enforcement.
"
0
Comment
Question by:anushahanna
2 Comments
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 500 total points
ID: 33432825
To remove a PK, it's usually..

alter table tbl drop constraint pk_name
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33432929
Thanks.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now