Question

MySQL ALTER column to remove primary key and auto_increment?

Answer 1

When you're not changing the name of the column you can use MODIFY : ALTER TABLE `companies` MODIFY `id` int(11), DROP PRIMARY KEY, ADD PRIMARY KEY (`uuid`);