ALTER TABLE Syntax ( My-SQL)

Link: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

ALTER TABLE Syntax

ALTER [IGNORE] TABLE tbl_name
   alter_specification [, alter_specification] ...

alter_specification:
   table_option ...
 | ADD [COLUMN] col_name column_definition
       [FIRST | AFTER col_name ]
 | ADD [COLUMN] (col_name column_definition,...)
 | ADD {INDEX|KEY} [index_name]
       [index_type] (index_col_name,...) [index_type]
 | ADD [CONSTRAINT [symbol]] PRIMARY KEY
       [index_type] (index_col_name,...) [index_type]
 | ADD [CONSTRAINT [symbol]]
       UNIQUE [INDEX|KEY] [index_name]
       [index_type] (index_col_name,...) [index_type]
 | ADD [FULLTEXT|SPATIAL] [INDEX|KEY] [index_name]
       (index_col_name,...) [index_type]
 | ADD [CONSTRAINT [symbol]]
       FOREIGN KEY [index_name] (index_col_name,...)
       reference_definition
 | ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
 | CHANGE [COLUMN] old_col_name new_col_name column_definition
       [FIRST|AFTER col_name]
 | MODIFY [COLUMN] col_name column_definition
       [FIRST | AFTER col_name]
 | DROP [COLUMN] col_name
 | DROP PRIMARY KEY
 | DROP {INDEX|KEY} index_name
 | DROP FOREIGN KEY fk_symbol
 | DISABLE KEYS
 | ENABLE KEYS
 | RENAME [TO] new_tbl_name
 | ORDER BY col_name [, col_name] ...
 | CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]
 | [DEFAULT] CHARACTER SET [=] charset_name [COLLATE [=] collation_name]
 | DISCARD TABLESPACE
 | IMPORT TABLESPACE