/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 vote159 views1 answer
Renommer base sql
SQL
0 vote161 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
4 votes145 views1 answer
Wildcard in sql
SQL
0 vote134 views1 answer
Ms Sql set us timezone
SQL
0 vote217 views1 answer
Sql to search who modified
SQL
4 votes165 views1 answer
Is there any command to change postgres password
SQL
4 votes247 views6 answers
Laravel jwt
SQL
23 votes111 views3 answers
Mysqldump
SQL
6 votes146 views2 answers
Mysql first day of month
SQL
15 votes172 views4 answers
Sql update from select
SQL

Share