Which SQL statement is used to delete all records from a table?OptionsDROPTRUNCATEDELETE ALLREMOVE
Question
Which SQL statement is used to delete all records from a table?OptionsDROPTRUNCATEDELETE ALLREMOVE
Solution
The SQL statement used to delete all records from a table is TRUNCATE.
Similar Questions
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
In SQL, which statement is used to remove a table definition and its data from the database?OptionsERASE TABLEDROP TABLEDELETE TABLEREMOVE TABLE
What is the SQL keyword used to remove a table from the database?OptionsERASE TABLEDELETE TABLEREMOVE TABLEDROP TABLE
Which of the following commands is used to delete all rows and free up space from a table?OptionsALTERDROPTRUNCATEDELETE
Which SQL statement is used to delete data FROM a database?COLLAPSEREMOVEALTERDELETE
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.