DROP Statements

    Deletes all tables inside the db database, then deletes the db database itself.

    Syntax:

    DROP TABLE

    Deletes the table.

    Syntax:

      DROP DICTIONARY

      Deletes the dictionary.

      Deletes a user.

      Syntax:

      DROP ROLE

      Deletes a role. The deleted role is revoked from all the entities where it was assigned.

      Syntax:

      1. DROP ROLE [IF EXISTS] name [,...] [ON CLUSTER cluster_name]

      DROP ROW POLICY

      Deletes a row policy. Deleted row policy is revoked from all the entities where it was assigned.

      1. DROP [ROW] POLICY [IF EXISTS] name [,...] ON [database.]table [,...] [ON CLUSTER cluster_name]

      Deletes a quota. The deleted quota is revoked from all the entities where it was assigned.

      Syntax:

      DROP SETTINGS PROFILE

      Deletes a settings profile. The deleted settings profile is revoked from all the entities where it was assigned.

      Syntax:

      1. DROP [SETTINGS] PROFILE [IF EXISTS] name [,...] [ON CLUSTER cluster_name]

      DROP VIEW

      Deletes a view. Views can be deleted by a command as well but DROP VIEW checks that [db.]name is a view.

        Оriginal article