SQL · Schema and constraints

drop table

Removes a table and its data. IF EXISTS makes it safe to rerun a script.

sqlRunnable example sql course

Syntax

drop table if exists name

Example

Open in the lab

CREATE TABLE temp_notes (id INTEGER);
DROP TABLE IF EXISTS temp_notes;
DROP TABLE IF EXISTS temp_notes;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.