Skip to content

DROP.md

Latest commit

 

History

History
19 lines (14 loc) · 555 Bytes

DROP.md

File metadata and controls

19 lines (14 loc) · 555 Bytes

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)