# Add a new Column
ALTER TABLE `student`
ADD `dob` DATE;
# Rename Column Name
ALTER TABLE `student`
RENAME COLUMN `dob` TO `date_of_birth`;
# Update Column Data Type
ALTER TABLE `student`
MODIFY COLUMN `date_of_birth` DATETIME;
# Drop a Column
ALTER TABLE `student`
DROP COLUMN `date_of_birth`;