Write an SQL command to remove the Primary Key constraint from a table, named MOBILE. M_ID is the primary key

Question

A) Write an SQL command to remove the Primary Key constraint from a table, named MOBILE. M_ID is the primary key of the table.

OR

B) Write an SQL command to make the column M_ID the Primary Key of an already existing table, named MOBILE.

Answer 1

A) ALTER TABLE MOBILE DROP PRIMARY KEY;

OR

B) ALTER TABLE MOBILE ADD PRIMARY KEY (M_ID);