An explicit DROP INDEX is not allowed on index

Posted on 2010-08-13
Medium Priority
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.
Question by:anushahanna
LVL 58

Accepted Solution

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

alter table tbl drop constraint pk_name

Author Comment

ID: 33432929

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

624 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