I have two different table having 20k entries each and mistakenly I have made summaryId as primary key and foreign key in the same table but now I want to remove the primary key constraint which is auto increament too. When I try drop primary key syntax it returns me an error :

**#1025 - Error on rename of '.\tg#sql-a38\_7f' to '.\tg\rest\_web\_availability\_summary\_pm' (errno: 150)** 

I tried the below query.

```
ALTER TABLE 'table_name' DROP PRIMARY KEY

```

If anybody has any idea please tell me how to remove primary key.