Delete A Table

Permanently remove a table and all its data with `DROP TABLE`.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Drop a temporary table and confirm other tables are unaffected

archive is dropped without error. The SELECT from products confirms that unrelated tables are not affected. To avoid an error if the table does not exist, use DROP TABLE IF EXISTS archive.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE archive (id INT);

CREATE TABLE products (id INT, name VARCHAR(50));

INSERT INTO
  products (id, name)
VALUES
  (1, 'Keyboard');

Validated query Shared across supported engines.

SQL

DROP TABLE archive;

SELECT
  id,
  name
FROM
  products
ORDER BY
  id;

Expected result Returned rows for the shared example.

id	name
1	Keyboard

Output is identical across all engines.

Useful when

Where this command helps.

removing a temporary or staging table after use
cleaning up tables that are no longer needed

Explanation

What the command is doing.

DROP TABLE deletes the table definition and all rows it contains. This operation is irreversible — there is no undo. Use DROP TABLE IF EXISTS to avoid an error when the table may not exist. Dropping a table that other tables reference via foreign keys will fail unless those dependencies are removed first.

Delete A Table

Drop a temporary table and confirm other tables are unaffected

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.