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://rebrand.ly/lex-group-70b557

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, 15 Sept 2025