/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 vote208 views1 answer
Hallo
SQL
1 vote219 views1 answer
Not exists mysql
SQL
2 votes216 views1 answer
Docker run postgres locally
SQL
0 vote227 views1 answer
Sql select merge multiple values
SQL
0 vote225 views1 answer
Mysql add comment to column
SQL
0 vote223 views2 answers
How to type a blank discord messgae
SQL
0 vote235 views3 answers
Sql drop all tables
SQL
0 vote232 views3 answers
Postgresql grant alter table to user
SQL
0 vote232 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote235 views1 answer
Mysql enter ubuntu
SQL

Share