All Products
Search

This Product

    Lindorm:DROP DATABASE

    Document Center

    Lindorm:DROP DATABASE

    Last Updated:Mar 28, 2026

    DROP DATABASE deletes a specified database.

    Applicable engines and versions

    EngineSupported versions
    LindormTable2.2.16 and later
    LindormTSDBAll versions

    Syntax

    DROP DATABASE [ IF EXISTS ] database_identifier

    Usage notes

    • SCHEMA is an alias for DATABASE. After you create a database, it is identified as DATABASE by default.

    • LindormTable 2.2.16 and later also accepts the equivalent syntax: DROP SCHEMA [ IF NOT EXISTS ] schema_identifier.

    • LindormTable versions earlier than 2.2.16 support only DROP SCHEMA [ IF NOT EXISTS ] schema_identifier and do not support DROP DATABASE.

    • The default database cannot be dropped.

    Example

    Drop the database named DB1. If the database does not exist, the statement completes without returning an error.

    DROP DATABASE IF EXISTS DB1;