drop primary key too slow ?

Hi Friends, I have a MyISAM table with about 10 million rows. When I drop the (multi-column) Primary Key (PK) it takes more than 10 minutes. I thought that any key or index was a kind of table in itself. And if so, dropping the PK could be as fast as a Truncate statement (a second). Am I missing so

Re: DROP PRIMARY KEY

* Silmara > When I try to use the following command > > ALTER TABLE TABLE_1 DROP PRIMARY KEY; > > I get one error > > ERROR1114: The table '#sql-240_2' is full > > My table have 309195 records. > > How can I resolve this problem? You probably have a ful

DROP PRIMARY KEY

Thanks for the answers, but I have other problem... When I try to use the following command ALTER TABLE TABLE_1 DROP PRIMARY KEY; I get one error ERROR1114: The table '#sql-240_2' is full My table have 309195 records. How can I resolve this problem? Kind re