/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

13 votes297 views2 answers
Sqlite rename column
SQL
0 vote307 views1 answer
Sqlite3 get data from table c
SQL
0 vote305 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote318 views1 answer
SQL SELECT-Klausel
SQL
37 votes401 views6 answers
Mysql update
SQL
16 votes300 views1 answer
CTE statement sql server
SQL
-1 vote335 views1 answer
Phinehas Psalm 106
SQL
2 votes320 views1 answer
Oracle percentage
SQL
0 vote337 views1 answer
SQL Server date literal
SQL
0 vote313 views1 answer
Utiliser sql ligne de commande
SQL

Share