/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

9 votes211 views6 answers
Replace sql
SQL
0 vote163 views1 answer
Alter rename command in mysql
SQL
0 vote161 views1 answer
Mysql workbench primary key
SQL
2 votes194 views1 answer
Oracle insert or update
SQL
0 vote264 views1 answer
Python get backup of sql
SQL
0 vote155 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
8 votes189 views1 answer
Racle create auto increment column
SQL
0 vote153 views1 answer
Alter table myisam to innodb
SQL
20 votes157 views3 answers
Update values in select statement sql
SQL
1 vote191 views1 answer
Insert many to many sql
SQL

Share