Webmaster2020.com

Posted: **Sun Nov 22, 2015 1:57 pm**

I would like to change the primary key of a table,
But don't know how to do that.

Do I have to drop the table and recreate it?
I don't want to do that.

Posted: **Sun Nov 22, 2015 4:50 pm**

You can use the following command:

Code: Select all

ALTER TABLE table DROP PRIMARY KEY, ADD PRIMARY KEY (col_a, col_b);

Webmaster2020.com

Solved: How do I change the primary key of a table?

Solved: How do I change the primary key of a table?

Re: How do I change the primary key of a table?