DROP

Keyword 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;

Note that [engine] is to be used when the database to be DROPped is hosed by a different engine (as for example IndexedDB or filestorage). Example:

DROP INDEXEDDB DATABASE db_name

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