cheat sheets.

add a column:
ALTER TABLE table_name ADD column_name datatype

drop a column:
ALTER TABLE table_name drop Gender column_name

modify datatype of column:
ALTER table table_name modify column_name datatype

completely change a column
ALTER table table_name change column_name new_column_name attributes