to drop primary key in mysql

to drop primary key in mysql

ALTER TABLE `mycheck` CHANGE COLUMN `id` `id` INT(23) NOT NULL, DROP PRIMARY KEY;