Change primary key sql

ALTER TABLE <Table_Name>
DROP CONSTRAINT <constraint_name>

ALTER TABLE <Table_Name>
ADD CONSTRAINT <constraint_name> PRIMARY KEY (<Column1>,<Column2>)

Source: stackoverflow.com

Similar codes

0 vote279 views2 answers
Dbms interview questions
SQL
1 vote272 views1 answer
Mysql dump specific tables
SQL
1 vote229 views1 answer
Restart identity postgresql
SQL
0 vote272 views1 answer
Mysql changer nom table
SQL
0 vote292 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote255 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote263 views1 answer
Get foreign table names mysql
SQL
0 vote272 views1 answer
Phpmyadmin tabellentyp ändern
SQL
11 votes294 views1 answer
Ddl view
SQL
0 vote264 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL