ChatGPT
Yes, TRUNCATE TABLE is another SQL command that can delete all records from a table without deleting the table itself. Unlike DELETE FROM, which removes rows one by one and can be rolled back using transaction logs, TRUNCATE TABLE is a faster operation that removes all rows in a single operation and cannot be rolled back within a transaction.
So, both DELETE FROM and TRUNCATE TABLE can effectively clear all records from a table while leaving the table structure intact.