/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

0 vote295 views1 answer
Sql get year from datetime field
SQL
0 vote297 views1 answer
Mysql zerofill
SQL
0 vote261 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote271 views1 answer
Sqlite select split string
SQL
3 votes272 views1 answer
Oracle get trigger ddl
SQL
1 vote278 views3 answers
How to truncate foreign key constraint table
SQL
2 votes309 views1 answer
Coalesce sql
SQL
7 votes321 views2 answers
Sql remove duplicates based on column
SQL
4 votes257 views1 answer
SQL order random
SQL
2 votes277 views1 answer
Sql update alias
SQL

Share