/SQL/Sql drop primary key

Sql drop primary key

Remove primary key from a table

 alter table Player DROP PRIMARY KEY;

2

Sql drop primary key

ALTER TABLE [table_name] DROP CONSTRAINT [primary_key_name]

2

Drop primary key

ALTER TABLE Student
DROP PRIMARY KEY;

0

Source: computerscienceai.com

Similar codes

3 votes209 views2 answers
Host is not allowed to connect to this mysql server
SQL
1 vote203 views1 answer
How refresh navicat tables to see new tables
SQL
2 votes214 views2 answers
Run mysql command from bash
SQL
0 vote193 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote223 views1 answer
Get who is hired in february in sql
SQL
0 vote232 views1 answer
T-sql update table variale
SQL
1 vote201 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote221 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
2 votes340 views5 answers
Unique in sql server
SQL
0 vote219 views3 answers
Constraint sql
SQL

Share