Skip to main content

DROP, TRUNCATE & RENAME

Learn DROP, TRUNCATE & RENAME (SQL Basics, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction DROP TABLE removes a table and its data. TRUNCATE TABLE empties it but keeps the structure. RENAME TABLE changes names atomically.

More lessons in SQL Basics