SQL Drop Table

The DROP TABLE command is used to permanently delete a table from a database. This removes not just the data, but also the entire table structure and associated metadata.

SQL Drop Table Syntax

DROP TABLE table_name;

DROP TABLE table_name;

SQL Truncate Table Syntax

This command deletes all data from a table but keeps its structure for future use

TRUNCATE TABLE table_name;

TRUNCATE TABLE table_name;

SQL Drop Table Example

This command removes that table entirely from the database

DROP TABLE Students;

DROP TABLE Students;

SQL Drop Table Labs