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.