Dropping a PK

[jeffmoore64]

Hi,
I'm trying to drop my PK. Here is the code I'm using:

alter table japan_rep.dbo.whm09_2 drop constraint PK_whm09_2


There are only 56 columns in the table and 2 fields. The table is not being used. I have let the above sql run for 10 minutes without completion.
What am I doing wrong here?

TIA

 

[ptheriault]

That syntax should work. How many records in the table. It could just be taking awhile because of the number of columns.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[jeffmoore64]

56 records, 2 fields in table ........

 

[ptheriault]

Are there any other indexes or triggers on the table that you need to keep?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[jeffmoore64]

I noticed that I'm being blocked my a query that has nothing to do with my "japan_rep" db.