All Products
Search

This Product

    Lindorm:DROP USER

    Document Center

    Lindorm:DROP USER

    Last Updated:Mar 28, 2026

    Deletes a specified user from a Lindorm instance. Before deleting a user, run SHOW USERS to view all existing users of the instance.

    Applicable engines and versions

    The DROP USER statement applies to all versions of LindormTable and LindormTSDB.

    Syntax

    drop_user_statement ::=  DROP USER [IF EXISTS] user_identifier

    Parameters

    Username (user_identifier)

    The username of the user to delete.

    If the specified username does not exist:

    • Without IF EXISTS: the statement returns an error indicating that the user does not exist.

    • With IF EXISTS: the statement terminates without returning an error.

    Examples

    Delete a user named test_user.

    DROP USER IF EXISTS test_user;