🎴 Flashcard Mode

TRUNCATE is a DDL command that removes all rows from a table while keeping the table structure intact. Unlike DELETE (which is DML and can be rolled back), TRUNCATE deallocates data pages, making it faster for clearing large tables. It does not drop the table itself, delete columns, or affect the database software.