Drop table

SQL Drop table

To drop a table from database uses the command DROP TABLE.

SQL Drop table syntax

DROP TABLE my_table_name;

Example

CREATE TABLE lessons
(
ID INT PRIMARY KEY,
TITLE VARCHAR(250) NOT NULL,
);

DROP TABLE lessons;