Which query can be used to Delete the column 'Birthday' from the Persons table?

DROP COLUMN Birthday FROM Persons;

ALTER TABLE Persons DROP COLUMN Birthday;

DELETE FROM Persons where COLUMN = 'Birthday';

ALTER TABLE Persons DELETE COLUMN Birthday;

Verified Answer
Correct Option - b
Anush said

To delete the column 'Birthday' from the 'Persons' table in SQL, you would use the following query:

Option 2: ALTER TABLE Persons DROP COLUMN Birthday;

The correct syntax for removing a column from a table is to use the ALTER TABLE statement with the DROP COLUMN clause, as shown in Option 2.

To get all Infosys Certified MySQL Associate Exam questions Join Telegram Group https://bit.ly/infy_premium_group

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Mon, 2 Jun 2025