SQL - Drop/Truncate Table

Overview

DROP TABLE removes a table and its data. TRUNCATE TABLE removes data quickly (DDL-like), but is not supported in SQLite; use DELETE instead.

TRUNCATE TABLE employees; -- be careful!
DROP TABLE employees; -- removes schema and data

TRUNCATE TABLE dbo.employees; -- be careful!
DROP TABLE dbo.employees;

-- No TRUNCATE; use DELETE FROM employees;
DROP TABLE employees; -- removes schema and data

name
tmp_x

No rows