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;
SQL Truncate Table Syntax
This command deletes all data from a table but keeps its structure for future use
TRUNCATE TABLE table_name;
SQL Drop Table Example
This command removes that table entirely from the database
DROP TABLE Students;
