/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 vote91 views1 answer
Oracle sql replace string in clob
SQL
3 votes118 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote121 views1 answer
Timestamp(0) postgresql
SQL
0 vote134 views1 answer
Sql reverse order of results
SQL
7 votes127 views1 answer
Safe update mysql
SQL
0 vote234 views1 answer
How to use select union and loop
SQL
0 vote124 views2 answers
Search stored procedures
SQL
12 votes140 views10 answers
Google
SQL
23 votes99 views3 answers
Mysqldump
SQL
6 votes136 views3 answers
Sql select last id
SQL

Share