DROP

DROP

Keyword for dropping databases, tables, views, columns, and indexes.

Syntax:

    DROP [engine] DATABASE alias;
    DROP TABLE table;
    ALTER TABLE table DROP COLUMN columnid;
    DROP INDEX index;

See also: [DROP DATABASE](Drop Database), [DROP TABLE](Drop Table), [DROP COLUMN](Drop Column), [DROP INDEX](Drop Index)