/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 vote236 views1 answer
Sql count matching group by
SQL
0 vote171 views1 answer
Get who is hired in specific month in sql
SQL
0 vote186 views1 answer
Mysql server not running
SQL
2 votes179 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
2 votes179 views2 answers
Enable foreign key checks postgres
SQL
11 votes186 views1 answer
Creating tables in sql with python
SQL
5 votes183 views2 answers
Oracle tables with column name
SQL
0 vote168 views1 answer
Sequelize postgresql schema
SQL
0 vote196 views1 answer
Oracle table privileges
SQL
0 vote247 views3 answers
Mysqli count down
SQL

Share