Alter

Alter Table

# 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`;