Drop Syntax

To delete a column, table, index or database DROP statement is used.
Delete a column

ALTER TABLE table_name DROP column col_name

Delete a table

DROP TABLE table_name

Delete an index

DROP INDEX table_name.index_name

Delete a databse

DROP DATABASE my_dbname