DROP

Find statements to remove database objects. This section details the syntax for deleting databases, tables, users, and other entities when they are no longer needed.

DROP DATABASE

Complete guide to removing databases in MariaDB. Complete DROP DATABASE syntax with IF EXISTS, permissions, and recovery options for production use.

DROP EVENT

Remove a scheduled event from the server. This command stops the event from executing and deletes its definition from the system tables.

DROP INDEX

Remove an existing index from a table. This command deletes the index structure, potentially impacting query performance but freeing storage.

DROP LOGFILE GROUP

Remove a log file group. This statement, primarily for NDB Cluster, deletes the undo log files associated with the specified log file group.

DROP PACKAGE BODY

Delete the body of a stored package. This command removes the implementation logic while preserving the package specification and interface.

DROP PACKAGE

Remove a stored package completely. This command deletes both the package specification (interface) and its body (implementation) from the database.

DROP SERVER

Remove a server definition. This command deletes the connection details for a remote server used by the FEDERATED or SPIDER storage engines.

DROP TABLE

Complete DROP TABLE syntax: TEMPORARY, IF EXISTS, WAIT/NOWAIT, RESTRICT/CASCADE options, metadata locks, atomic DROP, and replication behavior.

DROP TABLESPACE

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

DROP TRIGGER

Remove a trigger from a table. This command deletes the trigger definition, preventing it from firing on future INSERT, UPDATE, or DELETE events.

DROP VIEW

Explains how to use the DROP VIEW statement to remove one or more views from the database, including required privileges.