> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/data-definition/drop.md).

# DROP

{% columns %}
{% column %}
{% content-ref url="/pages/oESy184YHTbTfzrst8Wy" %}
[DROP DATABASE](/docs/server/reference/sql-statements/data-definition/drop/drop-database.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to removing databases in MariaDB. Complete DROP DATABASE syntax with IF EXISTS, permissions, and recovery options for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/CPkaq3ATZIQ1lhQb90Mo" %}
[DROP EVENT](/docs/server/reference/sql-statements/data-definition/drop/drop-event.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a scheduled event from the server. This command stops the event from executing and deletes its definition from the system tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Qv9RBVX7cOP6JGfNa9Yu" %}
[DROP INDEX](/docs/server/reference/sql-statements/data-definition/drop/drop-index.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove an existing index from a table. This command deletes the index structure, potentially impacting query performance but freeing storage.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/iov6ho2oXm1Nk4AzbyWH" %}
[DROP LOGFILE GROUP](/docs/server/reference/sql-statements/data-definition/drop/drop-logfile-group.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a log file group. This statement, primarily for NDB Cluster, deletes the undo log files associated with the specified log file group.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/uwOJLxJwe6V36tig63tG" %}
[DROP PACKAGE BODY](/docs/server/reference/sql-statements/data-definition/drop/drop-package-body.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Delete the body of a stored package. This command removes the implementation logic while preserving the package specification and interface.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/NSPFzyvQJWwYJ4edieIv" %}
[DROP PACKAGE](/docs/server/reference/sql-statements/data-definition/drop/drop-package.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a stored package completely. This command deletes both the package specification (interface) and its body (implementation) from the database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/F9tptmDEDE1SpmHwR70c" %}
[DROP SERVER](/docs/server/reference/sql-statements/data-definition/drop/drop-server.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a server definition. This command deletes the connection details for a remote server used by the FEDERATED or SPIDER storage engines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/UbmyaLXHXBtJIl3r1AIx" %}
[DROP TABLE](/docs/server/server-usage/tables/drop-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete DROP TABLE syntax: TEMPORARY, IF EXISTS, WAIT/NOWAIT, RESTRICT/CASCADE options, metadata locks, atomic DROP, and replication behavior.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/kHHcN4lSL484ojHNgS9d" %}
[DROP TABLESPACE](/docs/server/reference/sql-statements/data-definition/drop/drop-tablespace.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Delete a tablespace. This command removes the physical file container used for storing table data, applicable to engines like InnoDB or NDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ioM6bSi2GEQTwN9hlhQY" %}
[DROP TRIGGER](/docs/server/reference/sql-statements/data-definition/drop/drop-trigger.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a trigger from a table. This command deletes the trigger definition, preventing it from firing on future INSERT, UPDATE, or DELETE events.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zxsiHTOhoQbkmAe3KaT4" %}
[DROP VIEW](/docs/server/server-usage/views/drop-view.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains how to use the DROP VIEW statement to remove one or more views from the database, including required privileges.
{% endcolumn %}
{% endcolumns %}