/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 vote335 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote368 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote317 views1 answer
Mysql Error Code: 1005
SQL
18 votes349 views3 answers
Mysql add column default value
SQL
54 votes530 views6 answers
Sql rename column
SQL
0 vote344 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
2 votes325 views3 answers
How to pass password mysql command line
SQL
0 vote278 views1 answer
Get last run query sql server
SQL
1 vote348 views1 answer
Best sql course
SQL
0 vote384 views1 answer
Mssql find deadlocks
SQL

Share