Which SQL statement is used to delete all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE
Question
Which SQL statement is used to delete all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE
Solution 1
The SQL statement used to delete all records from a table is TRUNCATE.
Solution 2
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
Which SQL statement is used to delete data FROM a database?COLLAPSEREMOVEALTERDELETE
What is the SQL keyword used to remove a table from the database?OptionsERASE TABLEDELETE TABLEREMOVE TABLEDROP TABLE
Which SQL statement is used to delete data from a database?
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.