In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
Question
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
Solution
The command used in SQL to remove a table's data but keep the structure is TRUNCATE.
Similar Questions
In SQL, which command is used to remove a table's data but keep the structure?OptionsREMOVETRUNCATEDELETEDROP
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 all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE
What is the SQL keyword used to remove a table from the database?OptionsERASE TABLEDELETE TABLEREMOVE TABLEDROP TABLE
Which command is used for removing a table and all its data from the 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.