/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

1 vote202 views2 answers
Postgresql backup and restore globals and data
SQL
1 vote209 views1 answer
Add current timestamp in mysql
SQL
0 vote195 views1 answer
What is SQL data store?
SQL
17 votes192 views4 answers
Show tables sql server
SQL
4 votes185 views1 answer
Sql group by year
SQL
7 votes197 views2 answers
Execute mysql file
SQL
0 vote191 views1 answer
Default column value in sql same as other column
SQL
0 vote217 views1 answer
Oracle grant create job
SQL
0 vote206 views1 answer
Mysql get last 2 month data
SQL
27 votes212 views6 answers
Set password mysql
SQL

Share