DROP TABLE

DROP TABLE is a SQL statement in the DDL Statements category. Permanently removes a table and all its data from the database. Cannot be undone. The syntax is DROP TABLE [IF EXISTS] table_name;. It returns none (table removed). A typical example: DROP TABLE IF EXISTS temp_data; -- Use with extreme caution: this deletes everything permanently A close relative is CREATE TABLE, which creates a new table in the database with specified columns, data types, and constraints. A close relative is ALTER TABLE, which modifies an existing table: add/drop columns, modify data types, rename, add/drop constraints. A close relative is TRUNCATE TABLE, which removes ALL rows from a table quickly. Unlike DELETE, cannot be rolled back in most databases. Resets AUTO_INCREMENT. More about this category: Data Definition Language — CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE, CREATE INDEX. Related DDL Statements entries: CREATE TABLE, ALTER TABLE, TRUNCATE TABLE, RENAME TABLE, CREATE DATABASE, DROP DATABASE, CREATE SCHEMA, ALTER TABLE ADD COLUMN.