/SQL/Drop primary key

Drop primary key

Drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;

5

Source: techonthenet.com

Sql drop primary key

ALTER TABLE [table_name] DROP CONSTRAINT [primary_key_name]

3

Remove primary key from a table

 alter table Player DROP PRIMARY KEY;

2

Drop primary key

ALTER TABLE Student
DROP PRIMARY KEY;

0

Source: computerscienceai.com

Similar codes

0 vote283 views1 answer
Mysql edit trigger
SQL
0 vote275 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote244 views1 answer
Declarative base sqlalchemy
SQL
0 vote257 views2 answers
Sql join on comma separated field
SQL
0 vote263 views1 answer
Convert excel into sqllite db using python
SQL
1 vote248 views1 answer
Check message id sql server
SQL
0 vote266 views1 answer
SQL FROM-Klausel
SQL
0 vote210 views1 answer
Hangfire clean script
SQL
20 votes263 views3 answers
SQL query rename table
SQL
3 votes207 views2 answers
Mysql sum with condition
SQL

Share