MySQL: Alter Table Primary Key

1 year ago
Olivia Parker
1 minute

To change the primary key of a table, you can use the ALTER TABLE statement and specify the new primary key column in the table. Here is an example:

ALTER TABLE table_name
DROP PRIMARY KEY,
ADD PRIMARY KEY (new_primary_key_column);

In the example above, you need to replace “table_name” with the name of the table you want to modify, and replace “new_primary_key_column” with the column you want to set as the new primary key.

Please note that altering the primary key may impact the indexes and foreign key constraints in the table, so make sure your database design will not be affected before proceeding with this operation.

bannerAds