/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

6 votes150 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote125 views1 answer
Check if mysql is installed
SQL
2 votes130 views1 answer
Docker run postgres locally
SQL
0 vote113 views2 answers
Start mysql server using docker
SQL
0 vote112 views2 answers
Psql commande \gset
SQL
1 vote144 views1 answer
Mysql print variable
SQL
0 vote113 views1 answer
Formatting code with SQL Developer
SQL
0 vote107 views2 answers
Raise notice in postgresql function
SQL
0 vote165 views1 answer
Get last inserted primary key
SQL
0 vote106 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL

Share