ALTER a table in SQL

Use the following commands for add,change,drop table fields in SQL.
SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name>
ALTER TABLE  `test` ADD  `test INT NOT NULL
ALTER TABLE  `test` DROP `name`
ALTER TABLE  `test` CHANGE  `name`  `student_name` INT( 11 ) NOT NULL