/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 vote249 views2 answers
Mysql cast to varchar
SQL
1 vote185 views1 answer
Sql drop with dependencies
SQL
3 votes212 views2 answers
How to delete git repo locally
SQL
0 vote210 views1 answer
Mysql into outfile with headers
SQL
1 vote178 views1 answer
Foreign key constraint in ms sql
SQL
0 vote183 views1 answer
Console output pl sql
SQL
0 vote247 views1 answer
Mysql remove last character
SQL
0 vote184 views1 answer
Like sql for second letter of the family name
SQL
0 vote184 views1 answer
Mysql sql select one day before
SQL
1 vote194 views1 answer
Oracle undo usage per session
SQL

Share