Which SQL statement is used to delete all records from a table?OptionsDROPTRUNCATEDELETE ALLREMOVE

To delete all records from a table in SQL, the correct statement is TRUNCATE. Let's analyze the options provided:

1. DROP - This statement is used to remove an entire table from the database, not just the records.
2. TRUNCATE - This command removes all records from a table but does not remove the table itself. It is generally faster than deleting records one by one as it does not generate individual row delete log entries.
3. DELETE ALL - This is not a valid SQL statement. The correct command is just DELETE, and if you want to delete all records, you would typically use DELETE FROM table_name; without a WHERE clause.
4. REMOVE - This is also not a standard SQL command for deleting records from a table.

Final Answer

The correct SQL statement to delete all records from a table is TRUNCATE.